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);
}
