public void SetValuesToTempData_onChange(string SessionID, string UserID, string TargetObjectName, int Sequence, SP_GetContactPersonListToBindGrid_Result paraInput, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetContactPersonListToBindGrid_Result> existingList = new List <SP_GetContactPersonListToBindGrid_Result>();
existingList = GetContactPersonTempData(TargetObjectName, SessionID, UserID, conn);
List <SP_GetContactPersonListToBindGrid_Result> mergedAddToContactPersonList = new List <SP_GetContactPersonListToBindGrid_Result>();
//mergedAddToContactPersonList.AddRange(existingList);
//paraInput.Sequence = existingList.Count + 1;
//mergedAddToContactPersonList.Add(paraInput);
SP_GetContactPersonListToBindGrid_Result editRow = new SP_GetContactPersonListToBindGrid_Result();
editRow = (from exist in existingList
where exist.Sequence == Sequence
select exist).FirstOrDefault();
editRow = paraInput;
existingList = existingList.Where(e => e.Sequence != Sequence).ToList();
existingList.Add(editRow);
existingList = (from e in existingList
orderby e.Sequence
select e).ToList();
SaveTempDataToDB(existingList, SessionID, UserID, TargetObjectName, conn);
}
public static void PMSaveConatctPerson(object ContactPersonInfo)
{
iContactPersonInfoClient ContactPersonClient = new iContactPersonInfoClient();
try
{
CustomProfile profile = CustomProfile.GetProfile();
SP_GetContactPersonListToBindGrid_Result ContactPersonList = new SP_GetContactPersonListToBindGrid_Result();
if (Sequence != "" && Sequence != "0")
{
ContactPersonList = ContactPersonClient.GetContactPersonTempDataBySequence(Convert.ToInt64(Sequence), sessionID, TargetObject + "_ContactPerson", profile.Personal.UserID.ToString(), profile.DBConnection._constr);
ContactPersonList.Sequence = Convert.ToInt64(Sequence);
}
else
{
ContactPersonList.Sequence = 0;
}
Dictionary <string, object> rec = new Dictionary <string, object>();
rec = (Dictionary <string, object>)ContactPersonInfo;
ContactPersonList.ObjectName = TargetObject;
ContactPersonList.ReferenceID = Convert.ToInt64(Sequence);
ContactPersonList.CustomerHeadID = 0;
ContactPersonList.Sequence = Convert.ToInt64(Sequence);
ContactPersonList.Name = rec["Name"].ToString();
ContactPersonList.Department = Convert.ToInt64(rec["Department"].ToString());
ContactPersonList.Designation = rec["Designation"].ToString();
// ContactPersonList.Designation = rec["Designation"].ToString();
ContactPersonList.EmailID = rec["EmailID"].ToString();
ContactPersonList.OfficeNo = rec["OfficeNo"].ToString();
ContactPersonList.MobileNo = rec["MobileNo"].ToString();
ContactPersonList.ContactTypeID = Convert.ToInt64(rec["ContactTypeID"].ToString());
ContactPersonList.Remark = rec["Remark"].ToString();
ContactPersonList.Active = "N"; //rec["Active"].ToString(); //Active "N" = Is Archive
ContactPersonList.CreatedBy = profile.Personal.UserID.ToString();
ContactPersonList.CreationDate = DateTime.Now;
ContactPersonList.LastModifiedBy = profile.Personal.UserID.ToString();
ContactPersonList.LastModifiedDate = DateTime.Now;
ContactPersonList.CompanyID = profile.Personal.CompanyID;
//ContactPersonList.CompanyID = Convert.ToInt64(rec["hdncompanyid"].ToString()); ;
ContactPersonList.ContactType = rec["ContactType"].ToString();
ContactPersonList.selected = "";
if (Sequence != "0" && Sequence != "")
{
ContactPersonClient.SetValuesToTempData_onChange(sessionID, profile.Personal.UserID.ToString(), TargetObject + "_ContactPerson", Convert.ToInt32(Sequence), ContactPersonList, profile.DBConnection._constr);
}
else
{
ContactPersonClient.InsertIntoTemp(ContactPersonList, sessionID, profile.Personal.UserID.ToString(), TargetObject + "_ContactPerson", profile.DBConnection._constr);
}
ContactPersonClient.Close();
}
catch (System.Exception ex)
{
ContactPersonClient.Close();
Login.Profile.ErrorHandling(ex, "ContactPersonInfo.aspx", "PMSaveAddress");
}
}
public SP_GetContactPersonListToBindGrid_Result GetContactPersonTempDataBySequence(long SequenceNo, string SessionID, string TargetObjectName, string UserID, string[] conn)
{
List <SP_GetContactPersonListToBindGrid_Result> ContactPersonList = new List <SP_GetContactPersonListToBindGrid_Result>();
ContactPersonList = GetContactPersonTempData(TargetObjectName, SessionID, UserID, conn);
SP_GetContactPersonListToBindGrid_Result ContactPerson = new SP_GetContactPersonListToBindGrid_Result();
ContactPerson = ContactPersonList.Where(add => add.Sequence == SequenceNo).FirstOrDefault();
return(ContactPerson);
}
public SP_GetContactPersonListToBindGrid_Result GetContactDetailFromTempTableBySequence(string paraSessionID, string paraUserID, string currentFormID, int paraSequence, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
/*Begin : Get Existing Records from TempData*/
List <SP_GetContactPersonListToBindGrid_Result> existingAddToCartList = new List <SP_GetContactPersonListToBindGrid_Result>();
existingAddToCartList = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, currentFormID, conn);
/*End*/
/*Get Filter List [Filter By paraSequence]*/
SP_GetContactPersonListToBindGrid_Result filterList = new SP_GetContactPersonListToBindGrid_Result();
filterList = (from exist in existingAddToCartList
where exist.Sequence == paraSequence
select exist).FirstOrDefault();
return(filterList);
}
public void SetContactPersonArchive(string Ids, string isDeleted, string userId, string TargetObjectName, string SessionID, string[] conn)
{
List <SP_GetContactPersonListToBindGrid_Result> ContactPersonList = new List <SP_GetContactPersonListToBindGrid_Result>();
ContactPersonList = GetContactPersonTempData(TargetObjectName, SessionID, userId, conn);
string[] SeqArr = Ids.Split(',');
int[] SeqInts = SeqArr.Select(x => int.Parse(x)).ToArray();
for (int i = 0; i < SeqInts.Length; i++)
{
SP_GetContactPersonListToBindGrid_Result ContactPerson = new SP_GetContactPersonListToBindGrid_Result();
ContactPerson = ContactPersonList.Where(a => a.Sequence == SeqInts[i]).FirstOrDefault();
ContactPerson.Active = isDeleted;
}
SaveTempDataToDB(ContactPersonList, SessionID, userId, TargetObjectName, conn);
}
/// <summary>
/// Tis Is Method To Get Existing Record From tContactPersonDetail and tempdata and merge it
/// </summary>
/// <param name="paraSessionID"></param>
/// <param name="paraUserID"></param>
/// <param name="paraObjectName"></param>
/// <returns></returns>
public List <SP_GetContactPersonListToBindGrid_Result> GetExistingTempDataBySessionIDFormID(string paraSessionID, string paraUserID, string currentformid, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetContactPersonListToBindGrid_Result> ObjcontactPersonList = new List <SP_GetContactPersonListToBindGrid_Result>();
TempData tempdata = new TempData();
SP_GetContactPersonListToBindGrid_Result tcontact = new SP_GetContactPersonListToBindGrid_Result();
tempdata = (from temp in ce.TempDatas
where temp.SessionID == paraSessionID &&
temp.ObjectName == currentformid &&
temp.UserID == paraUserID
select temp).FirstOrDefault();
if (tempdata != null)
{
ObjcontactPersonList = datahelper.DeserializeEntity1 <SP_GetContactPersonListToBindGrid_Result>(tempdata.Data);
}
return(ObjcontactPersonList);
}
/// <summary>
/// This Is Method ToInsert Record In to TempData table
/// </summary>
/// <param name="ContactPerson"></param>
/// <param name="paraSessionID"></param>
/// <param name="paraUserID"></param>
/// <param name="paraObjectName"></param>
/// <returns></returns>
public List <SP_GetContactPersonListToBindGrid_Result> InsertIntoTemp(SP_GetContactPersonListToBindGrid_Result ContactPerson, string paraSessionID, string paraUserID, string currentformid, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
/*Begin : Get Existing Records from TempData*/
List <SP_GetContactPersonListToBindGrid_Result> existingContactPersonList = new List <SP_GetContactPersonListToBindGrid_Result>();
existingContactPersonList = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, currentformid, conn);
/*End*/
/*Begin : Merge (Existing + Newly Added) Products to Create TempData of AddToCart*/
List <SP_GetContactPersonListToBindGrid_Result> mergedContactPersonList = new List <SP_GetContactPersonListToBindGrid_Result>();
mergedContactPersonList.AddRange(existingContactPersonList);
ContactPerson.Sequence = existingContactPersonList.Count + 1;
mergedContactPersonList.Add(ContactPerson);
/*End*/
/*Begin : Serialize & Save MergedAddToCartList*/
SaveTempDataToDB(mergedContactPersonList, paraSessionID, paraUserID, currentformid, conn);
/*End*/
return(mergedContactPersonList);
}
protected void GetRecordFromTempDataBySequenceID(string SequenceNo)
{
SP_GetContactPersonListToBindGrid_Result ContactPerson = new SP_GetContactPersonListToBindGrid_Result();
iContactPersonInfoClient ContactPersonClient = new iContactPersonInfoClient();
try
{
//lblContactPersonFormHeader.Text = "Add New Conatct Person Info";
if (SequenceNo != "0")
{
if (sessionID == null)
{
sessionID = Session.SessionID;
}
lblContactPersonFormHeader.Text = "Edit Conatct Person Info";
CustomProfile profile = CustomProfile.GetProfile();
ContactPerson = ContactPersonClient.GetContactPersonTempDataBySequence(Convert.ToInt64(SequenceNo), sessionID, TargetObject + "_ContactPerson", profile.Personal.UserID.ToString(), profile.DBConnection._constr);
//ContactPerson = ContactPersonClient.GetContactPersonTempDataBySequence(Convert.ToInt64(SequenceNo), sessionID, "_ContactPerson", profile.Personal.UserID.ToString(), profile.DBConnection._constr);
txtName.Text = ContactPerson.Name;
//if (ContactPerson.Department != null) { txtDeparment.Text = ContactPerson.Department; }
if (ContactPerson.EmailID != null)
{
txtEmailID.Text = ContactPerson.EmailID;
}
if (ContactPerson.OfficeNo != null)
{
txtOfficeNo.Text = ContactPerson.OfficeNo;
}
if (ContactPerson.MobileNo != null)
{
txtMobileNo.Text = ContactPerson.MobileNo;
}
//ddldepartment.SelectedIndex = ddldepartment.Items.IndexOf(ddldepartment.Items.FindByValue(ContactPerson.Department.ToString()));
ddlcontacttype.SelectedIndex = ddlcontacttype.Items.IndexOf(ddlcontacttype.Items.FindByValue(ContactPerson.ContactTypeID.ToString()));
//if (ContactPerson.InterestedIn != null) { txtIntrestedIn.Text = ContactPerson.InterestedIn; }
//if (ContactPerson.Hobbies != null) { txtHobbies.Text = ContactPerson.Hobbies; }
//if (ContactPerson.FacebookID != null) { txtFacebookID.Text = ContactPerson.FacebookID; }
//if (ContactPerson.TwitterID != null) { txtTwitterID.Text = ContactPerson.TwitterID; }
//if (ContactPerson.OtherID != null) { txtOtherID.Text = ContactPerson.OtherID; }
//if (ContactPerson.HighestQualification != null) { txtHighestQualification.Text = ContactPerson.HighestQualification; }
//if (ContactPerson.CollegeOrUniversity != null) { txtCollege.Text = ContactPerson.CollegeOrUniversity; }
//if (ContactPerson.HighSchool != null) { txtHighScholl.Text = ContactPerson.HighSchool; }
if (ContactPerson.Remark != null)
{
txtremark.Text = ContactPerson.Remark;
}
rbtnActiveYes.Checked = true;
rbtnActiveNo.Checked = false;
if (ContactPerson.Active == "N")
{
rbtnActiveYes.Checked = false; rbtnActiveNo.Checked = true;
}
}
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "ConatactPerson.aspx.cs", "GetRecordFromTempDataBySequenceID");
}
finally { ContactPersonClient.Close(); }
}
