public ZA3620LD DoSave(ZA3620SD SaveData, String Mode)
{
ZA3620LD UsageD = new ZA3620LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", SaveData.UserData.ZaBase.SessionId),
new XElement("as_Category", SaveData.Category.ClasifdSpecDtlId),
new XElement("as_Sub_Category", SaveData.SubCategory.ClasifdSpecDtlId),
new XElement("as_Age", SaveData.Age.ClasifdSpecDtlId),
new XElement("as_Usage", SaveData.Usage.ClasifdSpecDtlId),
new XElement("as_Condition", SaveData.Condition.ClasifdSpecDtlId),
new XElement("as_Warranty", SaveData.Warranty.ClasifdSpecDtlId),
new XElement("as_title", SaveData.Title),
new XElement("as_Description", SaveData.Description),
new XElement("as_clasifdADMastID", SaveData.ClasifdADMastID)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3620_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable MotorData = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable MotorFileData = PLWM.Utils.GetDataTable(ds, 1);
if (MotorData.Rows.Count > 0)
{
DataRow Dr = MotorData.Rows[0];
UsageD.ClasifdADMastID = PLWM.Utils.CnvToNullableInt(Dr["clasifdADMastID"]);
UsageD.UserData.ZaBase.SessionId = PLWM.Utils.CnvToStr(Dr["sessionid"]);
UsageD.UserData.ZaBase.ErrorMsg = "";
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3620LD DoLoad(ZA3000D FilterData, String Mode)
{
ZA3620LD UsageD = new ZA3620LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", FilterData.ZaBase.SessionId),
new XElement("as_mode", Mode),
new XElement("as_email", FilterData.Email),
new XElement("as_passwd", FilterData.Passwd),
new XElement("ai_clasifd_ad_mast_id", FilterData.ZaBase.PKID)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3620_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable CategoryDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable SubCategoryDt = PLWM.Utils.GetDataTable(ds, 1);
System.Data.DataTable AgeDt = PLWM.Utils.GetDataTable(ds, 2);
System.Data.DataTable UsageDt = PLWM.Utils.GetDataTable(ds, 3);
System.Data.DataTable ConditionDT = PLWM.Utils.GetDataTable(ds, 4);
System.Data.DataTable WarrantyDT = PLWM.Utils.GetDataTable(ds, 5);
System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 6);
System.Data.DataTable dtSelData = PLWM.Utils.GetDataTable(ds, 7);
DataRow drUser = null;
if (dtUser.Rows.Count > 0)
{
drUser = dtUser.Rows[0];
}
UsageD.CategoryCol = new ZA3220DCol();
UsageD.CategoryCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = -1, ClasifdSpecValue = "Category"
});
foreach (DataRow dr in CategoryDt.Rows)
{
UsageD.CategoryCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]),
ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]),
});
}
UsageD.SubCategoryCol = new ZA3220DCol();
UsageD.SubCategoryCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = -1, ClasifdSpecValue = "Sub Category"
});
foreach (DataRow dr in SubCategoryDt.Rows)
{
UsageD.SubCategoryCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]),
ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]),
});
}
UsageD.AgeCol = new ZA3220DCol();
UsageD.AgeCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = -1, ClasifdSpecValue = "Age"
});
foreach (DataRow dr in AgeDt.Rows)
{
UsageD.AgeCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]),
ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]),
});
}
UsageD.UsageCol = new ZA3220DCol();
UsageD.UsageCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = -1, ClasifdSpecValue = "Usage"
});
foreach (DataRow dr in UsageDt.Rows)
{
UsageD.UsageCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]),
ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]),
});
}
UsageD.ConditionCol = new ZA3220DCol();
UsageD.ConditionCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = -1, ClasifdSpecValue = "Condition"
});
foreach (DataRow dr in ConditionDT.Rows)
{
UsageD.ConditionCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]),
ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]),
});
}
UsageD.WarrantyCol = new ZA3220DCol();
UsageD.WarrantyCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = -1, ClasifdSpecValue = "Warranty"
});
foreach (DataRow dr in WarrantyDT.Rows)
{
UsageD.WarrantyCol.Add(new ZA3220D()
{
ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]),
ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]),
});
}
UsageD.UserData = new ZA3000D()
{
ZaBase = new BaseD()
{
SessionId = PLWM.Utils.CnvToStr(drUser["SessionId"]),
UserName = PLWM.Utils.CnvToStr(drUser["FirstName"]),
ErrorMsg = "",
ZaKey = Utils.GetKey()
}
};
foreach (DataRow dr in dtSelData.Rows)
{
UsageD.SelectedDataDtl = new ZA3621SD()
{
Location = UsageD.LocationCol.FirstOrDefault(x => x.CityMastID == PLWM.Utils.CnvToStr(dtSelData.Rows[0]["city_mast_id"])),
Price = PLWM.Utils.CnvToInt(dtSelData.Rows[0]["Price"]),
};
}
foreach (DataRow dr in dtSelData.Rows)
{
UsageD.SelectedData = new ZA3620SD()
{
ClasifdADMastID = PLWM.Utils.CnvToInt(dtSelData.Rows[0]["clasifd_ad_mast_id"]),
Title = PLWM.Utils.CnvToStr(dtSelData.Rows[0]["clasifd_title"]),
Description = PLWM.Utils.CnvToStr(dtSelData.Rows[0]["clasifd_Description"]),
Category = UsageD.CategoryCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Category_id"])),
Age = UsageD.AgeCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Age_id"])),
Usage = UsageD.UsageCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Usage_id"])),
Condition = UsageD.ConditionCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Condition_id"])),
Warranty = UsageD.WarrantyCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Warranty_id"])),
};
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}