XML CRUD (Create Read Update Delete) Operation Using MVC

http://localhost:50868/api/Test/InsertProduct?strXml={"S_Name":"Bhimsen","F_Name":"Bhimsen","Address":"Noida"}http://localhost:50868/api/Test/UpdateProduct?strXml={"Pk_regid":"1","S_Name":"Bhimsen","F_Name":"Bhimsen","Address":"Noida"} using (var client = new System.Net.Http.HttpClient()) { client.BaseAddress = new Uri("http://localhost:50868/api/Test/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); var response = client.GetAsync("InsertProduct?strXml={'S_Name':'Bhimsen','F_Name':'Bhimsen','Address':'Noida'}").Result; if (response.IsSuccessStatusCode) { string responseString = response.Content.ReadAsStringAsync().Result; //Newtonsoft.Json.Linq.JObject json = Newtonsoft.Json.Linq.JObject.Parse(responseString); //product = Newtonsoft.Json.JsonConvert.DeserializeObject<Product>(responseString); } } ============================================== [HttpGet] [Route("api/Test/InsertProduct")] public HttpResponseMessage InsertProduct(string strXml) { try { } catch (Exception exp) { } return new HttpResponseMessage(HttpStatusCode.OK) { // Content = new StringContent(JsonConvert.SerializeObject(new Fee_Update_ParametersRequest { Status = this.Status, Error_Message = this.Error_Message, Checksum = this.Checksum })) }; } ============================================================== [HttpGet] [Route("api/Test/UpdateProduct")] public HttpResponseMessage UpdateProduct(string strXml) { try { } catch (Exception exp) { } return new HttpResponseMessage(HttpStatusCode.OK) { // Content = new StringContent(JsonConvert.SerializeObject(new Fee_Update_ParametersRequest { Status = this.Status, Error_Message = this.Error_Message, Checksum = this.Checksum })) };

DataAccess DAobj = new DataAccess(); ArrayList names = new ArrayList(); ArrayList types = new ArrayList(); ArrayList values = new ArrayList(); DataAccess objDAO = new DataAccess(); ArrayList size = new ArrayList(); ArrayList outtype = new ArrayList(); private string _xmlDoc, _fk_roleId, _fk_moduleId, _fk_webpageId, _fk_userId; #region Properties public string xmlDoc { set { _xmlDoc = value; } } protected void btnGetTechers_Click(object sender, EventArgs e) { try { string Message = ""; xmlDoc = GetMain(); if (ApproveDisableRejectTeacher(ref Message) > 0) { ClientMessaging("Record updated Successfully !"); \ ddlUserType.SelectedIndex = 0; D_ddlSession.SelectedIndex = 0; } else { dvData.Visible = true; ClientMessaging("Select atleast one record!"); } } catch (Exception ex) { } } public int ApproveDisableRejectTeacher(ref string Message) { string uid = Session["UserID"].ToString(); if (_xmlDoc.Contains("HPU_ExamTeacher_Mst")) { names.Clear(); values.Clear(); types.Clear(); names.Add("@userid"); types.Add(SqlDbType.VarChar); values.Add(uid); names.Add("@XmlDoc"); values.Add(_xmlDoc); types.Add(SqlDbType.VarChar); return DAobj.ExecuteTransactionMsg("HPU_Exam_SP_ApproveRejectTeacher", values, names, types, ref Message); } else { return 0; } } string GetMain() { try { DataRow dr = null; DataSet ds = objDAO.GetSchema("HPU_ExamTeacher_Mst"); foreach (GridViewRow row in gvdetils.Rows) { //string Message = ""; DropDownList ddlstatus = row.FindControl("D_ddlStatus") as Anthem.DropDownList; string ApprovalStatus = ddlstatus.Text; if (ApprovalStatus != "0") { HiddenField hdnTeacherid = row.FindControl("hdnTeacherid") as Anthem.HiddenField; int Pk_TeacherId = Convert.ToInt32(hdnTeacherid.Value); dr = ds.Tables[0].NewRow(); dr["Pk_TeacherId"] = Pk_TeacherId; dr["IsApproved"] = ApprovalStatus; ds.Tables[0].Rows.Add(dr); } } return ds.GetXml(); } catch (Exception ex) { //string Msg = ""; //PA_Login_And_Exception_Log.Insert_ExceptionLog("0", "", ex, HttpContext.Current.Request.UserHostAddress.ToString(), ref Msg); //DataSet dss = new DataSet(); return ""; } } Function =================== public DataSet GetSchema(string tblName) { SqlConnection Conn = DataAccess.Connect(); SqlCommand sqlCmd = new SqlCommand(); DataSet ds = new DataSet(); try { sqlCmd.Connection = Conn; SqlParameter IntPara = sqlCmd.Parameters.AddWithValue("@TableName", "Varchar(200)"); IntPara.Direction = ParameterDirection.Input; IntPara.Value = tblName; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_GetTableStructure"; sqlCmd.CommandTimeout = 1000000; SqlDataAdapter da = new SqlDataAdapter(sqlCmd); da.FillSchema(ds, SchemaType.Source, tblName); if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } sqlCmd.Dispose(); } catch { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } sqlCmd.Dispose(); throw; } return ds; } Procedure ================ CREATE PROCEDURE [dbo].[sp_GetTableStructure] @TableName Varchar(200) AS DECLARE @ERR Int SET @ERR = 0 BEGIN BEGIN TRY SET TRANSACTION ISOLATION LEVEL Serializable BEGIN SET DATEFORMAT dMy DECLARE @Sql nvarchar(500) SET @Sql='SELECT * FROM '+@TableName+' WHERE 1<>1' exec sp_executesql @Sql END END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK -- Raise an error with the details of the exception DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int SELECT @ErrMsg = ERROR_MESSAGE(), @ErrSeverity = ERROR_SEVERITY() RAISERROR(@ErrMsg, @ErrSeverity, 1) END CATCH END CREATE procedure HPU_Exam_SP_ApproveRejectTeacher ( @userid nvarchar(50), @XmlDoc nvarchar(max) ) as Begin DECLARE @idoc int Begin Try EXEC sp_xml_preparedocument @idoc OUTPUT, @XmlDoc SET TRANSACTION ISOLATION LEVEL READ COMMITTED SET NOCOUNT OFF; Update HPU_ExamTeacher_Mst ---select * from Acct_GuestFaculty_Mst set IsApproved = U.IsApproved From OPENXML ( @idoc, '/NewDataSet/HPU_ExamTeacher_Mst',2) with (Pk_TeacherId int,IsApproved varchar(15) )U Where HPU_ExamTeacher_Mst.Pk_TeacherId = U.Pk_TeacherId END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int SELECT @ErrMsg = ERROR_MESSAGE(), @ErrSeverity = ERROR_SEVERITY() RAISERROR(@ErrMsg, @ErrSeverity, 1) END CATCH end

Hi Good Example Just wanted to add if the XML Data File is Null it will through and exception need to handle that as Well

Nice one..

Nice

Good,Thanks for sharing