public JsonResult SaveShareTransfer(ShareTransferDetail objMFD) { objMFD.FirstShareTrans = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.FirstShareTrans); objMFD.DateofResolution = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.DateofResolution); objMFD.MemberName = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.MemberName); objMFD.MemberId = Convert.ToInt32(Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(Convert.ToString(objMFD.MemberId))); objMFD.FatherName = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.FatherName); objMFD.Address1 = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.Address1); objMFD.Address2 = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.Address2); objMFD.PostOffice = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.PostOffice); objMFD.NomineeName = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.NomineeName); objMFD.EmailId = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.EmailId); objMFD.OccupationVal = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.OccupationVal); objMFD.MemberName = XCCPrevent.FilterBadchars1(objMFD.MemberName); objMFD.FatherName = XCCPrevent.FilterBadchars1(objMFD.FatherName); objMFD.Address1 = XCCPrevent.FilterBadchars1(objMFD.Address1); objMFD.Address2 = XCCPrevent.FilterBadchars1(objMFD.Address2); objMFD.PostOffice = XCCPrevent.FilterBadchars1(objMFD.PostOffice); objMFD.NomineeName = XCCPrevent.FilterBadchars1(objMFD.NomineeName); objMFD.EmailId = XCCPrevent.FilterBadchars1(objMFD.EmailId); objMFD.Dob = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.Dob); objMFD.ShareTransferAppLetterNo = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.ShareTransferAppLetterNo); objMFD.ShareTransferApprovalDate = Convert.ToString(Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(Convert.ToString(objMFD.ShareTransferApprovalDate))); objMFD.ExistingMemberName = Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(objMFD.ExistingMemberName); objMFD.BrowserName = GetWebBrowserName(); objMFD.Updatedby = Convert.ToInt32(Session["UserId"]); objMFD.IPAddress = GetIPAddress(); objMFD.SocietyTransID = Convert.ToString(Session["SocietyTransID"]); if (!string.IsNullOrEmpty(objMFD.SocietyTransID)) { if (string.IsNullOrEmpty(objMFD.EmailId)) { objMFD.EmailId = ""; } if (!string.IsNullOrEmpty(objMFD.AadharNo)) { objMFD.AadharNo = objGBI.Encrypt(objMFD.AadharNo, Convert.ToString(Session["EncrptedDecruptedKey"])); } else { objMFD.AadharNo = ""; } if (Session["MemberPhoto"] != null) { objMFD.Imgg = (Byte[])Session["MemberPhoto"]; //objMFD.Extension = Convert.ToString(Session["FileExtension"]); objMFD.Fullpath = Convert.ToString(Session["FilePath"]); Session["MemberPhoto"] = (byte[])null; Session["FilePath"] = ""; } else { objMFD.Imgg = objBdata.GetImageByteForShare(objMFD.SocietyTransID, objMFD.ShareTransferID); } objMFD.MemberSNo = 0; return(Json(objBdata.SaveShareTransfer(objMFD), JsonRequestBehavior.AllowGet)); } return(Json("Kindly fill the first form then you can add committe members", JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteShareTransferMember(ShareTransferDetail objMFD) { var SocietyTransID = Convert.ToString(Session["SocietyTransID"]); var getAllRecord = objBdata.DeleteShareTransferMember(objMFD.ShareTransferID); var getRecord = objBdata.NewSocietyMembersList(SocietyTransID); Session["AddedMember"] = getRecord.Count; return(Json(getAllRecord, JsonRequestBehavior.AllowGet)); }
public int SaveShareTransfer(ShareTransferDetail objMFD) { connection.Open(); SqlCommand cmd = new SqlCommand("[dbo].[SaveShareTransferDetail]", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@imgg", objMFD.Imgg); cmd.Parameters.AddWithValue("@SocietyTransID", objMFD.SocietyTransID); cmd.Parameters.AddWithValue("@ShareTransferIde", objMFD.ShareTransferID); cmd.Parameters.AddWithValue("@MemberId", objMFD.MemberId); cmd.Parameters.AddWithValue("@MemberName", objMFD.MemberName); cmd.Parameters.AddWithValue("@FatherName", objMFD.FatherName); cmd.Parameters.AddWithValue("@Gender", objMFD.Gender); cmd.Parameters.AddWithValue("@Age", objMFD.Age); cmd.Parameters.AddWithValue("@Address1", objMFD.Address1); cmd.Parameters.AddWithValue("@Address2", objMFD.Address2); cmd.Parameters.AddWithValue("@PostOffice", objMFD.PostOffice); cmd.Parameters.AddWithValue("@Pin", objMFD.Pin); cmd.Parameters.AddWithValue("@DistCode", objMFD.DistCode); cmd.Parameters.AddWithValue("@NoOfShares", objMFD.NoOfShares); cmd.Parameters.AddWithValue("@NomineeName", objMFD.NomineeName); cmd.Parameters.AddWithValue("@OccupationVal", objMFD.OccupationVal); cmd.Parameters.AddWithValue("@NomineeAge", objMFD.NomineeAge); cmd.Parameters.AddWithValue("@RelationshipCode", objMFD.RelationshipCode); cmd.Parameters.AddWithValue("@Mobile", objMFD.Mobile); cmd.Parameters.AddWithValue("@AadharNo", objMFD.AadharNo); cmd.Parameters.AddWithValue("@EmailId", objMFD.EmailId); cmd.Parameters.AddWithValue("@dob", objMFD.Dob); cmd.Parameters.AddWithValue("@FullPath", objMFD.Fullpath); cmd.Parameters.AddWithValue("@ShareTransferAppLetterNo", objMFD.ShareTransferAppLetterNo); cmd.Parameters.AddWithValue("@ShareTransferApprovalDate", objMFD.ShareTransferApprovalDate); cmd.Parameters.AddWithValue("@ExistingMemberName", objMFD.ExistingMemberName); cmd.Parameters.AddWithValue("@IPAddress", objMFD.IPAddress); cmd.Parameters.AddWithValue("@BrowserName", objMFD.BrowserName); cmd.Parameters.AddWithValue("@LoginID", objMFD.Updatedby); cmd.Parameters.AddWithValue("@DateofResolution", objMFD.DateofResolution); cmd.Parameters.AddWithValue("@FirstShareTrans", objMFD.FirstShareTrans); var details = cmd.ExecuteNonQuery(); connection.Close(); if (details >= 1) { return(1); } return(0); }