public string GetContactPersonByName(string paraSessionID, string Name, string ContactType, string paraUserID, string currentFormID, string[] conn) { string Result = ""; BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); /*Begin : Get Existing Records from TempData*/ List <SP_GetContactPersonsByReferenceID_Result> existingAddToCartList = new List <SP_GetContactPersonsByReferenceID_Result>(); existingAddToCartList = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, currentFormID, conn); /*End*/ /*Get Filter List [Filter By paraSequence]*/ SP_GetContactPersonsByReferenceID_Result filterList = new SP_GetContactPersonsByReferenceID_Result(); filterList = (from exist in existingAddToCartList where exist.Name == Name && exist.ContactType == ContactType select exist).FirstOrDefault(); if (filterList == null) { } else { Result = "Same Contact Name Already Exist"; } return(Result); }
public SP_GetContactPersonsByReferenceID_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_GetContactPersonsByReferenceID_Result> existingAddToCartList = new List <SP_GetContactPersonsByReferenceID_Result>(); existingAddToCartList = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, currentFormID, conn); /*End*/ /*Get Filter List [Filter By paraSequence]*/ SP_GetContactPersonsByReferenceID_Result filterList = new SP_GetContactPersonsByReferenceID_Result(); filterList = (from exist in existingAddToCartList where exist.Sequence == paraSequence select exist).FirstOrDefault(); return(filterList); }
/// <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> protected List <SP_GetContactPersonsByReferenceID_Result> GetExistingTempDataBySessionIDFormID(string paraSessionID, string paraUserID, string currentformid, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); List <SP_GetContactPersonsByReferenceID_Result> ObjcontactPersonList = new List <SP_GetContactPersonsByReferenceID_Result>(); TempData tempdata = new TempData(); SP_GetContactPersonsByReferenceID_Result tcontact = new SP_GetContactPersonsByReferenceID_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_GetContactPersonsByReferenceID_Result>(tempdata.Data); } return(ObjcontactPersonList); }
public List <SP_GetContactPersonsByReferenceID_Result> SetValuesToTempData_onChange(string paraSessionID, string paraUserID, string currentformid, int paraSequence, SP_GetContactPersonsByReferenceID_Result paraInput, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); List <SP_GetContactPersonsByReferenceID_Result> existingList = new List <SP_GetContactPersonsByReferenceID_Result>(); existingList = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, currentformid, conn); SP_GetContactPersonsByReferenceID_Result editRow = new SP_GetContactPersonsByReferenceID_Result(); editRow = (from exist in existingList where exist.Sequence == paraSequence select exist).FirstOrDefault(); editRow = paraInput; existingList = existingList.Where(e => e.Sequence != paraSequence).ToList(); existingList.Add(editRow); existingList = (from e in existingList orderby e.Sequence select e).ToList(); SaveTempDataToDB(existingList, paraSessionID, paraUserID, currentformid, conn); return(existingList); }
/// <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_GetContactPersonsByReferenceID_Result> InsertIntoTemp(SP_GetContactPersonsByReferenceID_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_GetContactPersonsByReferenceID_Result> existingContactPersonList = new List <SP_GetContactPersonsByReferenceID_Result>(); existingContactPersonList = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, currentformid, conn); /*End*/ /*Begin : Merge (Existing + Newly Added) Products to Create TempData of AddToCart*/ List <SP_GetContactPersonsByReferenceID_Result> mergedContactPersonList = new List <SP_GetContactPersonsByReferenceID_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); }