/// <summary>
///
/// </summary>
/// <param name="CurrentObjectName"></param>
/// <param name="SessionID"></param>
/// <param name="CartSequence"></param>
/// <param name="TaxableAmount"></param>
/// <param name="SelectedTaxIDs"></param>
/// <returns></returns>
public string UpdateCalculatedTaxList(string CurrentObjectName, string SessionID, long CartSequence, decimal TaxableAmount, string SelectedTaxIDs, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ObjectParameter _CurrentObjectName = new ObjectParameter("CurrentObjectName", typeof(string));
_CurrentObjectName.Value = CurrentObjectName;
ObjectParameter _SessionID = new ObjectParameter("SessionID", typeof(string));
_SessionID.Value = SessionID;
ObjectParameter _CartSequence = new ObjectParameter("CartSequence", typeof(long));
_CartSequence.Value = CartSequence;
ObjectParameter _TaxableAmount = new ObjectParameter("TaxableAmount", typeof(decimal));
_TaxableAmount.Value = TaxableAmount;
ObjectParameter _SelectedTaxIDs = new ObjectParameter("SelectedTaxIDs", typeof(string));
_SelectedTaxIDs.Value = SelectedTaxIDs;
ObjectParameter[] obj = new ObjectParameter[] { _CurrentObjectName, _SessionID, _CartSequence, _TaxableAmount, _SelectedTaxIDs };
db.ExecuteFunction("SP_CartUpdateProductLevelTaxDetail", obj);
db.SaveChanges();
return(GetCalculatedTaxAmount(GetTaxListBySequence(CurrentObjectName, SessionID, CartSequence, conn)).ToString());
}
public void FinalSavePartDetail(string paraSessionID, string paraCurrentObjectName, long paraReferenceID, string paraUserID, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <POR_SP_GetPartDetails_OfConsumption_Result> finalSaveLst = new List <POR_SP_GetPartDetails_OfConsumption_Result>();
finalSaveLst = GetExistingTempDataBySessionIDObjectName(paraSessionID, paraUserID, paraCurrentObjectName, conn);
XElement xmlEle = new XElement("Consumed", from rec in finalSaveLst
select new XElement("PartList",
new XElement("ConH_ID", paraReferenceID),
new XElement("Prod_ID", Convert.ToInt64(rec.Prod_ID)),
new XElement("ConsumedQty", Convert.ToDecimal(rec.ConsumedQty)),
new XElement("Sequence", Convert.ToInt64(rec.Sequence)),
new XElement("GRND_ID", rec.GRND_ID)));
ObjectParameter _ConsumptionID = new ObjectParameter("ConsumptionID", typeof(long));
_ConsumptionID.Value = paraReferenceID;
ObjectParameter _xmlData = new ObjectParameter("xmlData", typeof(string));
_xmlData.Value = xmlEle.ToString();
ObjectParameter[] obj = new ObjectParameter[] { _ConsumptionID, _xmlData };
db.ExecuteFunction("POR_SP_InsertIntoPORtConsumptionDetail", obj);
db.SaveChanges();
ClearTempDataFromDB(paraSessionID, paraUserID, paraCurrentObjectName, conn);
}
public string FinalUpdateUCApproval(string Status, string Remark, string tApprovalIDs, long StatusChangedBy, string[] connstr)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(connstr));
ObjectParameter _Status = new ObjectParameter("Status", typeof(string));
_Status.Value = Status;
ObjectParameter _StatusChangedBy = new ObjectParameter("StatusChangedBy", typeof(long));
_StatusChangedBy.Value = StatusChangedBy;
ObjectParameter _Remark = new ObjectParameter("Remark", typeof(string));
_Remark.Value = Remark;
ObjectParameter _tApprovalIDs = new ObjectParameter("tApprovalIDs", typeof(string));
_tApprovalIDs.Value = tApprovalIDs;
ObjectParameter[] obj = new ObjectParameter[] { _Status, _StatusChangedBy, _Remark, _tApprovalIDs };
db.ExecuteFunction("SP_Update_tApprovalDetail", obj);
db.SaveChanges();
return("Records save successfully");
}
public void SaveUsersLocationDetails(long ToUserID, long Level, string LocationIDs, string CreatedBy, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
try
{
ObjectParameter SPUserID = new ObjectParameter("UserID", typeof(long));
SPUserID.Value = ToUserID;
ObjectParameter SPLevel = new ObjectParameter("Level", typeof(long));
SPLevel.Value = Level;
ObjectParameter SPTerritoryIDs = new ObjectParameter("TerritoryIDs", typeof(string));
SPTerritoryIDs.Value = LocationIDs;
ObjectParameter SPCreatedBy = new ObjectParameter("CreatedBy", typeof(string));
SPCreatedBy.Value = CreatedBy;
ObjectParameter[] obj = new ObjectParameter[] { SPUserID, SPLevel, SPTerritoryIDs, SPCreatedBy };
db.ExecuteFunction("SP_InsertIntomUserProfieTerritoryDetail", obj);
db.SaveChanges();
}
catch { }
finally { }
}
/// <summary>
/// Save SaveApprovalLevelDetail To DataBase
/// </summary>
/// <param name="paraObjectName"></param>
/// <param name="paraReferenceIDs"></param>
/// <param name="paraInput"></param>
/// <param name="paraUserID"></param>
/// <returns></returns>
public bool SaveApprovalLevelDetail(string paraUserIDs, long paraApprovalLevelID, mApprovalLevelDetail paraInput, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
bool result = false;
try
{
string[] strings = new string[] { };
strings = paraUserIDs.Split(',');
long[] arrayIDs = strings.Select(x => long.Parse(x)).ToArray();
List <mApprovalLevelDetail> objtApprovalDetail = new List <mApprovalLevelDetail>();
var ListofID = from a in arrayIDs.AsEnumerable()
select new { NewID = a };
XElement xmlApprovalDetail = new XElement("ApprovalDetailList", from a in ListofID
join m in objtApprovalDetail on a.NewID equals m.UserID into newTaskList
from newList in newTaskList.DefaultIfEmpty()
select new XElement("ApprovalList",
new XElement("ApprovalLevelID", paraInput.ApprovalLevelID),
new XElement("UserID", a.NewID),
new XElement("Active", paraInput.Active == null ? "Y" : paraInput.Active),
new XElement("CreatedBy", paraInput.CreatedBy == null ? "Admin" : paraInput.CreatedBy),
new XElement("CreationDate", paraInput.CreationDate == null ? DateTime.Now : paraInput.CreationDate),
new XElement("LastModifiedBy", paraInput.LastModifiedBy == null ? null : paraInput.LastModifiedBy),
new XElement("LastModifiedDate", paraInput.LastModifiedDate == null ? null : paraInput.LastModifiedDate),
new XElement("CompanyID", paraInput.CompanyID)
));
ObjectParameter _paraXML = new ObjectParameter("xmlData", typeof(string));
_paraXML.Value = xmlApprovalDetail.ToString();
ObjectParameter _paraApprovalLevelID = new ObjectParameter("paraApprovalLevelID", typeof(long));
_paraApprovalLevelID.Value = paraApprovalLevelID;
//ObjectParameter _paraUserIDs = new ObjectParameter("paraUserIDs", typeof(string));
//_paraUserIDs.Value = paraUserIDs;
ObjectParameter[] obj = new ObjectParameter[] { _paraXML, _paraApprovalLevelID };
ce.ExecuteFunction("SP_InsetIntoApprovalLevelDetail", obj);
ce.SaveChanges();
result = true;
}
catch (Exception ex)
{
result = false;
// uc.ErrorTracking(ex, UserID, ConnectionStr);
}
return(result);
}
public void FinalSaveToDBtInventoryProductDetail(string paraSessionID, long paraReferenceID, string paraUserID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetProductListForInventory_Result> paraobjList = new List <SP_GetProductListForInventory_Result>();
paraobjList = GetTempDataByObjectNameSessionID(paraSessionID, paraUserID, conn);
XElement xmlEle = new XElement("InventoryProductDetailList", from rec in paraobjList
select new XElement("InventoryProduct",
new XElement("ID", rec.ID),
new XElement("Sequence", rec.Sequence),
new XElement("ProductID", rec.ProductID),
new XElement("ProductName", rec.ProductName),
new XElement("UOM", rec.UOM),
new XElement("Quantity", rec.Quantity),
new XElement("ProductRate", rec.ProductRate),
new XElement("Remark", rec.Remark)
));
TempData tempdata = new TempData();
tempdata = (ce.TempDatas.Where(a => a.ObjectName == "InventoryProduct" && a.SessionID == paraSessionID)).FirstOrDefault();
tempdata.XmlData = xmlEle.ToString();
tempdata.LastUpdated = DateTime.Now;
tempdata.SessionID = paraSessionID.ToString();
tempdata.UserID = paraUserID.ToString();
tempdata.ObjectName = "InventoryProduct";
tempdata.TableName = "table";
ce.SaveChanges();
ObjectParameter _paraSessionID = new ObjectParameter("paraSessionID", typeof(string));
_paraSessionID.Value = paraSessionID;
ObjectParameter _paraObjectName = new ObjectParameter("paraObjectName", typeof(string));
_paraObjectName.Value = "InventoryProduct";
ObjectParameter _paraReferenceID = new ObjectParameter("paraReferenceID", typeof(long));
_paraReferenceID.Value = paraReferenceID;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(string));
_paraUserID.Value = paraUserID;
ObjectParameter[] obj = new ObjectParameter[] { _paraSessionID, _paraObjectName, _paraReferenceID, _paraUserID };
ce.ExecuteFunction("SP_InsertIntoTInventoryDetail", obj);
ce.SaveChanges();
ClearTempData(paraSessionID, paraUserID, conn);
}
public bool FinalSaveGWCUserRoles(List <SP_GWCGetUserRoleDetail_Result> sessionList, string userID, long userIDForRole, long CompanyID, long RoleID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
try
{
if (sessionList.Count > 0)
{
XElement xmlEle = new XElement("RoleMasterList", from rec in sessionList.AsEnumerable()
select new XElement("RoleMaster",
new XElement("ObjectName", rec.ObjectName),
new XElement("Add", rec.Add),
new XElement("Edit", rec.Edit),
new XElement("View", rec.View),
new XElement("Delete", rec.Delete),
new XElement("Approval", rec.Approval),
new XElement("AssignTask", rec.AssignTask)
));
ObjectParameter _paraxmlData = new ObjectParameter("xmlData", typeof(string));
_paraxmlData.Value = xmlEle.ToString();
ObjectParameter _paraCompanyID = new ObjectParameter("paraCompanyID", typeof(long));
_paraCompanyID.Value = CompanyID;
ObjectParameter _paraUserIDForRole = new ObjectParameter("paraUserIDForRole", typeof(long));
_paraUserIDForRole.Value = userIDForRole;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(long));
_paraUserID.Value = userID;
ObjectParameter _paraRoleID = new ObjectParameter("paraRoleID", typeof(long));
_paraRoleID.Value = RoleID;
ObjectParameter[] obj = new ObjectParameter[] { _paraxmlData, _paraCompanyID, _paraUserIDForRole, _paraUserID, _paraRoleID };
ce.ExecuteFunction("SP_InsertIntoUserRoleDetail", obj);
ce.SaveChanges();
}
return(true);
}
catch { return(false); }
}
public void FinalSave(List <SP_GetDataToBindRoleMaster_Result> sessionList, mRole objmRole, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
if (objmRole.ID == 0)
{
db.AddTomRoles(objmRole); db.SaveChanges();
}
else
{
db.mRoles.Attach(objmRole);
db.ObjectStateManager.ChangeObjectState(objmRole, EntityState.Modified); db.SaveChanges();
}
if (sessionList.Count > 0)
{
XElement xmlEle = new XElement("RoleMasterList", from rec in sessionList.AsEnumerable()
select new XElement("RoleMaster",
new XElement("ObjectName", rec.ObjectName),
new XElement("Add", rec.Add),
new XElement("Edit", rec.Edit),
new XElement("View", rec.View),
new XElement("Delete", rec.Delete),
new XElement("Approval", rec.Approval),
new XElement("AssignTask", rec.AssignTask)
));
ObjectParameter _paraXmlData = new ObjectParameter("xmlData", typeof(string));
_paraXmlData.Value = xmlEle.ToString();
ObjectParameter _paraRoleID = new ObjectParameter("paraRoleID", typeof(long));
_paraRoleID.Value = objmRole.ID;
ObjectParameter _paraCompanyID = new ObjectParameter("paraCompanyID", typeof(long));
_paraCompanyID.Value = objmRole.CompanyID;
ObjectParameter[] obj = new ObjectParameter[] { _paraXmlData, _paraRoleID, _paraCompanyID };
db.ExecuteFunction("SP_InsertIntoRoleMasterDetail", obj);
db.SaveChanges();
}
}
/// <summary>
/// Save Record To tStatutryDetails
/// </summary>
/// <param name="ObjStatutory"></param>
/// <param name="paraObjectName"></param>
/// <param name="paraReferenceID"></param>
/// <param name="paraUserID"></param>
/// <param name="paraCompanyID"></param>
public void FinalSaveToTStatutoryDetails(List <tStatutoryDetail> ObjStatutory, string paraObjectName, long paraReferenceID, string paraUserID, long paraCompanyID, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
if (ObjStatutory.Count > 0)
{
XElement xmlEleStatutory = new XElement("StatutoryList", from rec in ObjStatutory
select new XElement("Statutory",
new XElement("ObjectName", paraObjectName),
new XElement("ReferenceID", paraReferenceID),
new XElement("StatutoryID", rec.StatutoryID),
new XElement("StatutoryValue", rec.StatutoryValue),
new XElement("Active", rec.Active),
new XElement("CreatedBy", paraUserID),
new XElement("CreatedDate", rec.CreatedDate),
new XElement("LastEditBy", paraUserID),
new XElement("LastEditDate", rec.LastEditDate),
new XElement("CompanyID", rec.CompanyID)
));
ObjectParameter _paraXML = new ObjectParameter("xmlData", typeof(string));
_paraXML.Value = xmlEleStatutory.ToString();
ObjectParameter _paraObjectName = new ObjectParameter("paraObjectName", typeof(string));
_paraObjectName.Value = paraObjectName;
ObjectParameter _paraReferenceID = new ObjectParameter("paraReferenceID", typeof(string));
_paraReferenceID.Value = paraReferenceID;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(string));
_paraUserID.Value = paraUserID;
ObjectParameter _paraCompanyID = new ObjectParameter("paraCompanyID", typeof(string));
_paraCompanyID.Value = paraCompanyID;
ObjectParameter[] obj = new ObjectParameter[] { _paraXML, _paraObjectName, _paraReferenceID, _paraUserID, _paraCompanyID };
db.ExecuteFunction("SP_InsertIntotStatutoryDetails", obj);
db.SaveChanges();
}
}
public void FinalSaveReceiptPartDetail(string paraSessionID, string paraCurrentObjectName, long GRNH_ID, string paraUserID, string ReceiptStatus, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <POR_SP_GetPartDetails_OfGRN_Result> finalSaveLst = new List <POR_SP_GetPartDetails_OfGRN_Result>();
finalSaveLst = GetExistingTempDataBySessionIDObjectName(paraSessionID, paraUserID, paraCurrentObjectName, conn);
XElement xmlEle = new XElement("Receipt", from rec in finalSaveLst
select new XElement("PartList",
new XElement("GRNH_ID", GRNH_ID),
new XElement("Prod_ID", Convert.ToInt64(rec.Prod_ID)),
new XElement("ChallanQty", Convert.ToDecimal(rec.ChallanQty)),
new XElement("ReceivedQty", Convert.ToDecimal(rec.ReceivedQty)),
new XElement("ExcessQty", Convert.ToDecimal(rec.ExcessQty)),
new XElement("ShortQty", Convert.ToDecimal(rec.ShortQty)),
new XElement("Sequence", Convert.ToInt64(rec.Sequence)),
new XElement("MIND_ID", Convert.ToInt64(rec.MIND_ID)),
new XElement("UOMID", Convert.ToInt64(rec.UOMID))));
ObjectParameter _ReceiptID = new ObjectParameter("ReceiptID", typeof(long));
_ReceiptID.Value = GRNH_ID;
ObjectParameter _xmlData = new ObjectParameter("xmlData", typeof(string));
_xmlData.Value = xmlEle.ToString();
ObjectParameter[] obj = new ObjectParameter[] { _ReceiptID, _xmlData };
db.ExecuteFunction("POR_SP_InsertIntoPORtGRNDetail", obj);
db.SaveChanges();
if (ReceiptStatus == "Received")
{
EmailSendWhenMaterialReceived(GRNH_ID, conn);
}
ClearTempDataFromDB(paraSessionID, paraUserID, paraCurrentObjectName, conn);
}
/// <summary>
///
/// </summary>
/// <param name="CurrentObjectName"></param>
/// <param name="SessionID"></param>
public void ClearTempDataByCurrentObjectSessionID(string CurrentObjectName, string SessionID, string[] conn)
{
try
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ObjectParameter _CurrentObjectName = new ObjectParameter("CurrentObjectName", typeof(string));
_CurrentObjectName.Value = CurrentObjectName;
ObjectParameter _SessionID = new ObjectParameter("SessionID", typeof(string));
_SessionID.Value = SessionID;
ObjectParameter _CartSequence = new ObjectParameter("CartSequence", typeof(long));
_CartSequence.Value = 0;
ObjectParameter[] obj = new ObjectParameter[] { _CurrentObjectName, _SessionID, _CartSequence };
db.ExecuteFunction("SP_CartDeleteProductLevelTaxDetail", obj);
db.SaveChanges();
}
catch
{
}
}
/// <summary>
///
/// </summary>
/// <param name="CurrentObjectName"></param>
/// <param name="SessionID"></param>
/// <param name="CartSequence"></param>
public bool RemoveTaxDetailBySequence(string CurrentObjectName, string SessionID, long CartSequence, string[] conn)
{
try
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ObjectParameter _CurrentObjectName = new ObjectParameter("CurrentObjectName", typeof(string));
_CurrentObjectName.Value = CurrentObjectName;
ObjectParameter _SessionID = new ObjectParameter("SessionID", typeof(string));
_SessionID.Value = SessionID;
ObjectParameter _CartSequence = new ObjectParameter("CartSequence", typeof(long));
_CartSequence.Value = CartSequence;
ObjectParameter[] obj = new ObjectParameter[] { _CurrentObjectName, _SessionID, _CartSequence };
db.ExecuteFunction("SP_CartDeleteProductLevelTaxDetail", obj);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="CurrentObjectName"></param>
/// <param name="ReferenceID"></param>
/// <param name="SessionID"></param>
/// <returns></returns>
public bool FinalSaveProductLevelTax(string CurrentObjectName, long ReferenceID, string SessionID, string[] conn)
{
try
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ObjectParameter _CurrentObjectName = new ObjectParameter("CurrentObjectName", typeof(string));
_CurrentObjectName.Value = CurrentObjectName;
ObjectParameter _SessionID = new ObjectParameter("SessionID", typeof(string));
_SessionID.Value = SessionID;
ObjectParameter _ReferenceID = new ObjectParameter("ReferenceID", typeof(long));
_ReferenceID.Value = ReferenceID;
ObjectParameter[] obj = new ObjectParameter[] { _CurrentObjectName, _SessionID, _ReferenceID };
db.ExecuteFunction("SP_CartInsertIntoProductLevelTaxDetail", obj);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 9. FinalSaveToDBtAddToCartProductDetail
/// a. Define ObjectParameter to Passvalues for SQL StoreProcedure
/// b. Call : SP_InsertIntoAddToCartProductDetail [ SQL StoreProcedure for BulkInsert ]
/// c. Call : ClearTempDataFromDB
/// </summary>
/// <param name="paraSessionID"></param>
/// <param name="paraCurrentObjectName"></param>
/// <param name="paraReferenceID"></param>
/// <param name="paraUserID"></param>
public void FinalSaveToDBtAddToCartProductDetail(string paraSessionID, string paraCurrentObjectName, long paraReferenceID, string paraUserID, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetCartProductDetail_Result> finalSaveLst = new List <SP_GetCartProductDetail_Result>();
finalSaveLst = GetExistingTempDataBySessionIDObjectName(paraSessionID, paraUserID, paraCurrentObjectName, conn);
XElement xmlEle = new XElement("AddToCartList", from rec in finalSaveLst
select new XElement("AddToCartProduct",
new XElement("ID", rec.ID),
new XElement("ObjectName", paraCurrentObjectName),
new XElement("ReferenceID", paraReferenceID),
new XElement("Sequence", rec.Sequence),
new XElement("ProductID", rec.ProductID),
new XElement("ProductCode", rec.ProductCode),
new XElement("ProductName", rec.ProductName),
new XElement("ProductDescription", rec.ProductDescription),
new XElement("UOMID", rec.UOMID),
new XElement("UOM", rec.UOM),
new XElement("ProductPrice", rec.ProductPrice),
new XElement("PerUnitDiscount", rec.PerUnitDiscount),
new XElement("IsDiscountPercent", rec.IsDiscountPercent),
new XElement("DiscountID", rec.DiscountID),
new XElement("RateAfterDiscount", rec.RateAfterDiscount),
new XElement("Quantity", rec.Quantity),
new XElement("AmountAfterDiscount", rec.AmountAfterDiscount),
new XElement("TotalTaxAmount", rec.TotalTaxAmount),
new XElement("AmountAfterTax", rec.AmountAfterTax),
new XElement("Remark", rec.Remark)
));
TempData tempdata = new TempData();
tempdata = (from t in db.TempDatas
where t.ObjectName == paraCurrentObjectName && t.SessionID == paraSessionID && t.UserID == paraUserID
select t).FirstOrDefault();
tempdata.XmlData = xmlEle.ToString();
tempdata.LastUpdated = DateTime.Now;
tempdata.SessionID = paraSessionID.ToString();
tempdata.UserID = paraUserID.ToString();
tempdata.ObjectName = paraCurrentObjectName.ToString();
tempdata.TableName = "table";
db.SaveChanges();
ObjectParameter _SessionID = new ObjectParameter("SessionID", typeof(string));
_SessionID.Value = paraSessionID;
ObjectParameter _ReferenceID = new ObjectParameter("ReferenceID", typeof(long));
_ReferenceID.Value = paraReferenceID;
ObjectParameter _UserID = new ObjectParameter("UserID", typeof(string));
_UserID.Value = paraUserID;
ObjectParameter _CurrentObjectName = new ObjectParameter("CurrentObjectName", typeof(string));
_CurrentObjectName.Value = paraCurrentObjectName;
ObjectParameter[] obj = new ObjectParameter[] { _SessionID, _ReferenceID, _UserID, _CurrentObjectName };
db.ExecuteFunction("SP_InsertIntoCartProductDetail", obj);
db.SaveChanges();
ClearTempDataFromDB(paraSessionID, paraUserID, paraCurrentObjectName, conn);
}
/// <summary>
/// 9. FinalSaveToDBtDiscountMappingDetails
/// a. Define ObjectParameter to Passvalues for SQL StoreProcedure
/// b. Call : SP_InsertIntoAddToCartProductDetail [ SQL StoreProcedure for BulkInsert ]
/// c. Call : ClearTempDataFromDB
/// </summary>
/// <param name="paraSessionID"></param>
/// <param name="paraObjectName"></param>
/// <param name="paraReferenceID"></param>
/// <param name="paraUserID"></param>
public void FinalSaveToDBtDiscountMappingDetails(string paraSessionID, string paraObjectName_Old, long paraReferenceID, string paraUserID, string paraObjectName_New, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetTermConditionListForUCTermCondition_Result> finalSaveLst = new List <SP_GetTermConditionListForUCTermCondition_Result>();
finalSaveLst = GetExistingTempDataBySessionIDObjectName(paraSessionID, paraUserID, paraObjectName_Old, conn);
XElement xmlEle = new XElement("TermConditionList", from rec in finalSaveLst
select new XElement("TermCondition",
new XElement("ID", rec.ID),
new XElement("Sequence", rec.Sequence),
new XElement("ObjectName", paraObjectName_New),
new XElement("ReferenceID", paraReferenceID),
new XElement("TermID", rec.TermID),
new XElement("Term", rec.Term),
new XElement("Condition", rec.Condition),
new XElement("Active", rec.Active),
new XElement("CreatedBy", paraUserID),
new XElement("CreationDate", rec.CreatedDate),
new XElement("LastModifiedBy", paraUserID),
new XElement("LastModifiedDate", rec.LastModifyDate),
new XElement("CompanyID", rec.CompanyID)
));
TempData tempdata = new TempData();
//tempdata = (from t in db.TempDatas
// where t.ObjectName == "Discount" && t.SessionID == paraSessionID && t.UserID == paraUserID
// select t).FirstOrDefault();
tempdata = (db.TempDatas.Where(a => a.ObjectName == paraObjectName_Old && a.SessionID == paraSessionID)).FirstOrDefault();
tempdata.XmlData = xmlEle.ToString();
tempdata.LastUpdated = DateTime.Now;
tempdata.SessionID = paraSessionID.ToString();
tempdata.UserID = paraUserID.ToString();
tempdata.ObjectName = paraObjectName_Old;
tempdata.TableName = "table";
//db.TempDatas.Attach(tempdata);
// db.ObjectStateManager.ChangeObjectState(tempdata, EntityState.Modified);
db.SaveChanges();
ObjectParameter _paraSessionID = new ObjectParameter("paraSessionID", typeof(string));
_paraSessionID.Value = paraSessionID;
ObjectParameter _paraObjectName_Old = new ObjectParameter("paraObjectName_Old", typeof(string));
_paraObjectName_Old.Value = paraObjectName_Old;
ObjectParameter _paraObjectName_New = new ObjectParameter("paraObjectName_New", typeof(string));
_paraObjectName_New.Value = paraObjectName_New;
ObjectParameter _paraReferenceID = new ObjectParameter("paraReferenceID", typeof(long));
_paraReferenceID.Value = paraReferenceID;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(string));
_paraUserID.Value = paraUserID;
ObjectParameter[] obj = new ObjectParameter[] { _paraSessionID, _paraObjectName_Old, _paraReferenceID, _paraUserID, _paraObjectName_New };
db.ExecuteFunction("SP_InsertIntotTermsConditionsDetail", obj);
db.SaveChanges();
ClearTempDataFromDB(paraSessionID, paraUserID, paraObjectName_Old, conn);
}
public void FinalSaveToDBtInventoryProductDetail(string paraSessionID, long paraReferenceID, string paraUserID, string paraContainer, string paraEngineModel, string paraEngineSerial, string paraFailureCauses, string paraFailureNature, string paraGenerateModel, long paraFailureHrs, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetProductListForPartRequisition_Result> paraobjList = new List <SP_GetProductListForPartRequisition_Result>();
paraobjList = GetTempDataByObjectNameSessionID(paraSessionID, paraUserID, conn);
XElement xmlEle = new XElement("PartRequisitionProductDetailList", from rec in paraobjList
select new XElement("PartRequisitionProduct",
new XElement("ID", rec.ID),
new XElement("Sequence", rec.Sequence),
new XElement("ProductID", rec.ProductID),
new XElement("ProductCode", rec.ProductCode),
new XElement("ProductName", rec.ProductName),
new XElement("Description", rec.Description),
new XElement("UOM", rec.UOM),
new XElement("ReqQty", rec.ReqQty),
new XElement("ProductRate", rec.ProductRate),
new XElement("IssueQty", rec.IssueQty),
new XElement("ReciptQty", rec.ReciptQty),
new XElement("SiteProd_Bal", rec.SiteProd_Bal)
));
TempData tempdata = new TempData();
tempdata = (ce.TempDatas.Where(a => a.ObjectName == "PartRequisitionProduct" && a.SessionID == paraSessionID)).FirstOrDefault();
tempdata.XmlData = xmlEle.ToString();
tempdata.LastUpdated = DateTime.Now;
tempdata.SessionID = paraSessionID.ToString();
tempdata.UserID = paraUserID.ToString();
tempdata.ObjectName = "PartRequisitionProduct";
tempdata.TableName = "table";
ce.SaveChanges();
ObjectParameter _paraSessionID = new ObjectParameter("paraSessionID", typeof(string));
_paraSessionID.Value = paraSessionID;
ObjectParameter _paraObjectName = new ObjectParameter("paraObjectName", typeof(string));
_paraObjectName.Value = "PartRequisitionProduct";
ObjectParameter _paraReferenceID = new ObjectParameter("paraReferenceID", typeof(long));
_paraReferenceID.Value = paraReferenceID;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(string));
_paraUserID.Value = paraUserID;
ObjectParameter _paraContainer = new ObjectParameter("paraContainer", typeof(string));
_paraContainer.Value = paraContainer;
ObjectParameter _paraEngineModel = new ObjectParameter("paraEngineModel", typeof(string));
_paraEngineModel.Value = paraEngineModel;
ObjectParameter _paraEngineSerial = new ObjectParameter("paraEngineSerial", typeof(string));
_paraEngineSerial.Value = paraEngineSerial;
ObjectParameter _paraFailureCauses = new ObjectParameter("paraFailureCauses", typeof(string));
_paraFailureCauses.Value = paraFailureCauses;
ObjectParameter _paraFailureNature = new ObjectParameter("paraFailureNature", typeof(string));
_paraFailureNature.Value = paraFailureNature;
ObjectParameter _paraGenerateModel = new ObjectParameter("paraGenerateModel", typeof(string));
_paraGenerateModel.Value = paraGenerateModel;
ObjectParameter _paraFailureHrs = new ObjectParameter("paraFailureHrs", typeof(long));
_paraFailureHrs.Value = paraFailureHrs;
ObjectParameter[] obj = new ObjectParameter[] { _paraSessionID, _paraObjectName, _paraReferenceID, _paraUserID, _paraContainer, _paraEngineModel, _paraEngineSerial, _paraFailureCauses, _paraFailureNature, _paraGenerateModel, _paraFailureHrs };
ce.ExecuteFunction("SP_InsertIntotPartReqDetail", obj);
ce.SaveChanges();
ClearTempData(paraSessionID, paraUserID, conn);
}
/// <summary>
/// This Is Method To Save Record In tAddress
/// </summary>
/// <param name="paraSessionID"></param>
/// <param name="paraObjectName"></param>
/// <param name="paraReferenceID"></param>
/// <param name="paraUserID"></param>
public void FinalSaveToDBttAddress(string paraSessionID, string currentformid, long paraReferenceID, string paraUserID, string paraSaveObjectName, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <tAddress> finalSaveLst = new List <tAddress>();
finalSaveLst = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, currentformid, conn);
if (finalSaveLst.Count > 0)
{
XElement xmlEle = new XElement("AddToAddressList", from rec in finalSaveLst
select new XElement("AddressList",
new XElement("ID", rec.ID),
new XElement("ObjectName", paraSaveObjectName),
new XElement("ReferenceID", rec.ReferenceID),
new XElement("Sequence", rec.Sequence),
new XElement("AddressType", rec.AddressType),
new XElement("AddressLine1", rec.AddressLine1),
new XElement("AddressLine2", rec.AddressLine2),
new XElement("AddressLine3", rec.AddressLine3),
new XElement("RouteID", rec.RouteID),
new XElement("Landmark", rec.Landmark),
new XElement("County", rec.County),
new XElement("State", rec.State),
new XElement("City", rec.City),
new XElement("Zipcode", rec.Zipcode),
new XElement("PhoneNo", rec.PhoneNo),
new XElement("FaxNo", rec.FaxNo),
new XElement("EmailID", rec.EmailID),
new XElement("IsDefault", rec.IsDefault),
new XElement("Active", rec.Active),
new XElement("CompanyID", rec.CompanyID)));
TempData tempdata = new TempData();
tempdata = (from t in ce.TempDatas
where t.ObjectName == currentformid && t.SessionID == paraSessionID && t.UserID == paraUserID
select t).FirstOrDefault();
tempdata.XmlData = xmlEle.ToString();
ce.ObjectStateManager.ChangeObjectState(tempdata, EntityState.Modified);
ce.SaveChanges();
ObjectParameter _paraSessionID = new ObjectParameter("paraSessionID", typeof(string));
_paraSessionID.Value = paraSessionID;
ObjectParameter _paraSaveObjectName = new ObjectParameter("paraSaveObjectName", typeof(string));
_paraSaveObjectName.Value = paraSaveObjectName;
ObjectParameter _paraReferenceID = new ObjectParameter("paraReferenceID", typeof(long));
_paraReferenceID.Value = paraReferenceID;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(string));
_paraUserID.Value = paraUserID;
ObjectParameter _paraCurrentFormID = new ObjectParameter("paraCurrentFormID", typeof(string));
_paraCurrentFormID.Value = currentformid;
ObjectParameter[] obj = new ObjectParameter[] { _paraSessionID, _paraSaveObjectName, _paraReferenceID, _paraUserID, _paraCurrentFormID };
ce.ExecuteFunction("SP_InsertIntoAddressList", obj);
ce.SaveChanges();
}
}
public void FinalSaveToDBtAddToContactPerson(string paraSessionID, string TargetObjectName, long paraReferenceID, string paraUserID, string paraSaveObjectName, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetContactPersonListToBindGrid_Result> finalSaveLst = new List <SP_GetContactPersonListToBindGrid_Result>();
finalSaveLst = GetExistingTempDataBySessionIDFormID(paraSessionID, paraUserID, TargetObjectName, conn);
if (finalSaveLst.Count > 0)
{
XElement xmlEle = new XElement("AddToContactList", from rec in finalSaveLst
select new XElement("ContactList",
new XElement("ObjectName", paraSaveObjectName),
new XElement("ReferenceID", rec.ReferenceID),
new XElement("CustomerHeadID", rec.CustomerHeadID),
new XElement("Sequence", rec.Sequence),
new XElement("Name", rec.Name),
new XElement("Department", rec.Department),
new XElement("Designation", rec.Designation),
new XElement("EmailID", rec.EmailID),
new XElement("OfficeNo", rec.OfficeNo),
new XElement("MobileNo", rec.MobileNo),
new XElement("ContactTypeID", rec.ContactTypeID),
new XElement("InterestedIn", rec.InterestedIn),
new XElement("Hobbies", rec.Hobbies),
new XElement("FacebookID", rec.FacebookID),
new XElement("FacebookPassword", rec.FacebookPassword),
new XElement("TwitterID", rec.TwitterID),
new XElement("TwitterPassword", rec.TwitterPassword),
new XElement("OtherID", rec.OtherID),
new XElement("HighestQualification", rec.HighestQualification),
new XElement("CollegeOrUniversity", rec.CollegeOrUniversity),
new XElement("HighSchool", rec.HighSchool),
new XElement("Remark", rec.Remark),
new XElement("Active", rec.Active),
new XElement("CreatedBy", rec.CreatedBy),
new XElement("CreationDate", rec.CreationDate),
new XElement("LastModifiedBy", rec.LastModifiedBy),
new XElement("LastModifiedDate", rec.LastModifiedDate),
new XElement("CompanyID", rec.CompanyID),
new XElement("Remark", rec.Remark)
)
);
TempData tempdata = new TempData();
tempdata = (from t in ce.TempDatas
where t.ObjectName == TargetObjectName && t.SessionID == paraSessionID && t.UserID == paraUserID
select t).FirstOrDefault();
tempdata.XmlData = xmlEle.ToString();
ce.ObjectStateManager.ChangeObjectState(tempdata, EntityState.Modified);
ce.SaveChanges();
//ClearTempDataFromDB(paraSessionID, paraUserID, paraObjectName);
}
ObjectParameter _paraSessionID = new ObjectParameter("paraSessionID", typeof(string));
_paraSessionID.Value = paraSessionID;
ObjectParameter _paraSaveObjectName = new ObjectParameter("paraSaveObjectName", typeof(string));
_paraSaveObjectName.Value = paraSaveObjectName;
ObjectParameter _paraReferenceID = new ObjectParameter("paraReferenceID", typeof(long));
_paraReferenceID.Value = paraReferenceID;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(string));
_paraUserID.Value = paraUserID;
ObjectParameter _TargetObjectName = new ObjectParameter("paraCurrentFormID", typeof(string));
_TargetObjectName.Value = TargetObjectName;
ObjectParameter[] obj = new ObjectParameter[] { _paraSessionID, _paraSaveObjectName, _paraReferenceID, _paraUserID, _TargetObjectName };
ce.ExecuteFunction("SP_InsertIntotContactPersonDetail", obj);
ce.SaveChanges();
ClearTempDataFromDB(paraSessionID, paraUserID, paraSaveObjectName, conn);
}
/// <summary>
/// 9. FinalSaveToDBtDiscountMappingDetails
/// a. Define ObjectParameter to Passvalues for SQL StoreProcedure
/// b. Call : SP_InsertIntoAddToCartProductDetail [ SQL StoreProcedure for BulkInsert ]
/// c. Call : ClearTempDataFromDB
/// </summary>
/// <param name="paraSessionID"></param>
/// <param name="paraObjectName"></param>
/// <param name="paraDiscountID"></param>
/// <param name="paraUserID"></param>
public void FinalSaveToDBtTargetPlanDetails(string paraSessionID, long paraTargetID, string paraUserID, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetProductListForTargetPlan_Result> finalSaveLst = new List <SP_GetProductListForTargetPlan_Result>();
finalSaveLst = GetExistingTempDataBySessionIDObjectName(paraSessionID, paraUserID, conn);
XElement xmlEle = new XElement("ProducttargetList", from rec in finalSaveLst
select new XElement("Producttarget",
new XElement("ID", rec.ID),
new XElement("Sequence", rec.Sequence),
new XElement("ProductID", rec.ProductID),
new XElement("ProductCode", rec.ProductCode),
new XElement("ProductName", rec.ProductName),
new XElement("PrincipalPrice", rec.PrincipalPrice),
new XElement("UOM", rec.UOM),
new XElement("Quantity", rec.Quantity),
new XElement("TargetAmount", rec.TargetAmount),
new XElement("Active", rec.Active),
new XElement("CreatedBy", paraUserID),
new XElement("CreationDate", DateTime.Now),
new XElement("LastModifiedBy", paraUserID),
new XElement("LastModifiedDate", DateTime.Now)
));
TempData tempdata = new TempData();
//tempdata = (from t in db.TempDatas
// where t.ObjectName == "Discount" && t.SessionID == paraSessionID && t.UserID == paraUserID
// select t).FirstOrDefault();
tempdata = (db.TempDatas.Where(a => a.ObjectName == "Target" && a.SessionID == paraSessionID)).FirstOrDefault();
tempdata.XmlData = xmlEle.ToString();
tempdata.LastUpdated = DateTime.Now;
tempdata.SessionID = paraSessionID.ToString();
tempdata.UserID = paraUserID.ToString();
tempdata.ObjectName = "Target";
tempdata.TableName = "table";
//db.TempDatas.Attach(tempdata);
// db.ObjectStateManager.ChangeObjectState(tempdata, EntityState.Modified);
db.SaveChanges();
ObjectParameter _paraSessionID = new ObjectParameter("paraSessionID", typeof(string));
_paraSessionID.Value = paraSessionID;
//ObjectParameter _paraObjectName = new ObjectParameter("paraObjectName", typeof(string));
//_paraObjectName.Value = "Discount";
ObjectParameter _paratargetID = new ObjectParameter("paraTargetID", typeof(long));
_paratargetID.Value = paraTargetID;
ObjectParameter _paraUserID = new ObjectParameter("paraUserID", typeof(string));
_paraUserID.Value = paraUserID;
ObjectParameter[] obj = new ObjectParameter[] { _paraSessionID, _paratargetID, _paraUserID };
db.ExecuteFunction("SP_InsertIntotTargetPlanDetails", obj);
db.SaveChanges();
ClearTempDataFromDB(paraSessionID, paraUserID, conn);
}
