public ZA3600LD DoSave(ZA3600SD SaveData, String Mode)
{
ZA3600LD MotorSpecD = new ZA3600LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", SaveData.UserData.ZaBase.SessionId),
new XElement("as_Year", SaveData.Year.MotorSpecDtlId),
new XElement("as_Colour", SaveData.Colour.MotorSpecDtlId),
new XElement("as_Doors", SaveData.Doors.MotorSpecDtlId),
new XElement("as_Warranty", SaveData.Warranty.MotorSpecDtlId),
new XElement("as_RegionalSpecs", SaveData.RegionalSpecs.MotorSpecDtlId),
new XElement("as_Transmisson", SaveData.Transmisson.MotorSpecDtlId),
new XElement("as_BodyType", SaveData.BodyType.MotorSpecDtlId),
new XElement("as_FuelType", SaveData.FuelType.MotorSpecDtlId),
new XElement("as_Cylinders", SaveData.Cylinders.MotorSpecDtlId),
new XElement("as_SellerType", SaveData.SellerType.MotorSpecDtlId),
new XElement("as_Brand", SaveData.Brand.MotorSpecDtlId),
new XElement("as_HoursePower", SaveData.HoursePower.MotorSpecDtlId),
new XElement("as_Title", SaveData.Title),
new XElement("as_KiloMetrs", SaveData.KiloMetrs),
new XElement("as_Description", SaveData.Description),
new XElement("as_MotorsADMastID", SaveData.MotorsADMastID),
new XElement("as_ConditionID", SaveData.Condition.MotorSpecDtlId)));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3600_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];
MotorSpecD.MotorsADMastID = PLWM.Utils.CnvToNullableInt(Dr["MotorsADMastID"]);
MotorSpecD.UserData.ZaBase.SessionId = PLWM.Utils.CnvToStr(Dr["sessionid"]);
MotorSpecD.UserData.ZaBase.ErrorMsg = "";
}
}
catch (Exception e)
{
MotorSpecD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(MotorSpecD);
}
public ZA3700ILD DoDelete(ZA3600LD FilterData)
{
ZA3700ILD UsageD = new ZA3700ILD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("ai_motors_ad_mast_id", FilterData.MotorsADMastID)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3700AD_Del", XString, PLABSM.DbProvider.MSSql);
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3600LD DoLoad(ZA3000D FilterData, String Mode)
{
ZA3600LD MotorSpecD = new ZA3600LD();
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_motors_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("ZA3600_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable YearDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable ColourDt = PLWM.Utils.GetDataTable(ds, 1);
System.Data.DataTable DoorsDt = PLWM.Utils.GetDataTable(ds, 2);
System.Data.DataTable WarrantyDt = PLWM.Utils.GetDataTable(ds, 3);
System.Data.DataTable RegionalSpecsDT = PLWM.Utils.GetDataTable(ds, 4);
System.Data.DataTable TransmissonDT = PLWM.Utils.GetDataTable(ds, 5);
System.Data.DataTable BodyTypeDT = PLWM.Utils.GetDataTable(ds, 6);
System.Data.DataTable FuelTypeDT = PLWM.Utils.GetDataTable(ds, 7);
System.Data.DataTable CylindersDT = PLWM.Utils.GetDataTable(ds, 8);
System.Data.DataTable SellerTypeDT = PLWM.Utils.GetDataTable(ds, 9);
System.Data.DataTable ExtrasDT = PLWM.Utils.GetDataTable(ds, 10);
System.Data.DataTable TechinalFeaturesDT = PLWM.Utils.GetDataTable(ds, 11);
System.Data.DataTable HoursePowerDT = PLWM.Utils.GetDataTable(ds, 12);
System.Data.DataTable BrandColDT = PLWM.Utils.GetDataTable(ds, 13);
System.Data.DataTable ConditionDT = PLWM.Utils.GetDataTable(ds, 14);
System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 15);
System.Data.DataTable dtSelectedData = PLWM.Utils.GetDataTable(ds, 16);
DataRow drUser = null;
if (dtUser.Rows.Count > 0)
{
drUser = dtUser.Rows[0];
}
MotorSpecD.YearCol = new ZA3200DCol();
MotorSpecD.YearCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Year"
});
foreach (DataRow dr in YearDt.Rows)
{
MotorSpecD.YearCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.ColourCol = new ZA3200DCol();
MotorSpecD.ColourCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Colour"
});
foreach (DataRow dr in ColourDt.Rows)
{
MotorSpecD.ColourCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.DoorsCol = new ZA3200DCol();
MotorSpecD.DoorsCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Doors"
});
foreach (DataRow dr in DoorsDt.Rows)
{
MotorSpecD.DoorsCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.WarrantyCol = new ZA3200DCol();
MotorSpecD.WarrantyCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Warranty"
});
foreach (DataRow dr in WarrantyDt.Rows)
{
MotorSpecD.WarrantyCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.RegionalSpecsCol = new ZA3200DCol();
MotorSpecD.RegionalSpecsCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Regional Specs"
});
foreach (DataRow dr in RegionalSpecsDT.Rows)
{
MotorSpecD.RegionalSpecsCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.TransmissonCol = new ZA3200DCol();
MotorSpecD.TransmissonCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Transmisson Type"
});
foreach (DataRow dr in TransmissonDT.Rows)
{
MotorSpecD.TransmissonCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.BodyTypeCol = new ZA3200DCol();
MotorSpecD.BodyTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Body Type"
});
foreach (DataRow dr in BodyTypeDT.Rows)
{
MotorSpecD.BodyTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.FuelTypeCol = new ZA3200DCol();
MotorSpecD.FuelTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Fuel Type"
});
foreach (DataRow dr in FuelTypeDT.Rows)
{
MotorSpecD.FuelTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.CylindersCol = new ZA3200DCol();
MotorSpecD.CylindersCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = " No. of Cylinders"
});
foreach (DataRow dr in CylindersDT.Rows)
{
MotorSpecD.CylindersCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.SellerTypeCol = new ZA3200DCol();
MotorSpecD.SellerTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Listed by"
});
foreach (DataRow dr in SellerTypeDT.Rows)
{
MotorSpecD.SellerTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.ExtrasCol = new ZA3200DCol();
foreach (DataRow dr in ExtrasDT.Rows)
{
MotorSpecD.ExtrasCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.TechinalFeaturesCol = new ZA3200DCol();
foreach (DataRow dr in TechinalFeaturesDT.Rows)
{
MotorSpecD.TechinalFeaturesCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.HoursePowerCol = new ZA3200DCol();
MotorSpecD.HoursePowerCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Horsepower"
});
foreach (DataRow dr in HoursePowerDT.Rows)
{
MotorSpecD.HoursePowerCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.BrandCol = new ZA3200DCol();
MotorSpecD.BrandCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Brand"
});
foreach (DataRow dr in BrandColDT.Rows)
{
MotorSpecD.BrandCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.ConditionCol = new ZA3200DCol();
MotorSpecD.ConditionCol.Add(new ZA3200D()
{
MotorSpecDtlId = -1, MotorSpecValue = "Condition"
});
foreach (DataRow dr in ConditionDT.Rows)
{
MotorSpecD.ConditionCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]),
});
}
MotorSpecD.UserData = new ZA3000D()
{
ZaBase = new BaseD()
{
SessionId = PLWM.Utils.CnvToStr(drUser["SessionId"]),
UserName = PLWM.Utils.CnvToStr(drUser["FirstName"]),
ErrorMsg = "",
ZaKey = Utils.GetKey()
}
};
if (dtSelectedData.Rows.Count > 0)
{
MotorSpecD.SelectedData = new ZA3600SD()
{
BodyType = MotorSpecD.BodyTypeCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["BodyType_id"])),
Brand = MotorSpecD.BrandCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Brand_id"])),
Colour = MotorSpecD.ColourCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Colour_id"])),
Condition = MotorSpecD.ConditionCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["condition_id"])),
Cylinders = MotorSpecD.CylindersCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Cylinders_id"])),
Doors = MotorSpecD.DoorsCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Doors_id"])),
FuelType = MotorSpecD.FuelTypeCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["FuelType_id"])),
HoursePower = MotorSpecD.HoursePowerCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["HoursePower_id"])),
RegionalSpecs = MotorSpecD.RegionalSpecsCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["RegionalSpecs_id"])),
SellerType = MotorSpecD.SellerTypeCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["SellerType_id"])),
Year = MotorSpecD.YearCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Year_id"])),
Warranty = MotorSpecD.WarrantyCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Warranty_id"])),
Transmisson = MotorSpecD.TransmissonCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Transmisson_id"])),
KiloMetrs = PLWM.Utils.CnvToStr(dtSelectedData.Rows[0]["Kmters"]),
Title = PLWM.Utils.CnvToStr(dtSelectedData.Rows[0]["mot_Title"]),
Description = PLWM.Utils.CnvToStr(dtSelectedData.Rows[0]["mot_Description"]),
MotorsADMastID = PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["motors_ad_mast_id"]),
};
}
}
catch (Exception e)
{
MotorSpecD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(MotorSpecD);
}