private Vendor BuiltVendorDomain(VendorBo vendorBo)
{
return((Vendor) new Vendor().InjectFrom(vendorBo));
}
//create Vendor
public TransactionStatus CreateVendor(VendorBo vendorBo)
{
var transactionStatus = new TransactionStatus();
var vendor = BuiltVendorDomain(vendorBo);
DateTime dt = new DateTime();
dt = DateTime.Now;
int value = 1;
string flag = "true";
string LMK = "LMK";
//Image upload
#region using sql helper
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", value), //32
new SqlParameter("@CityID", vendor.City_Id), //0
new SqlParameter("@Vndr_Name", vendor.Vndr_Name), //6
new SqlParameter("@Vndr_Cinno", vendor.Vndr_Cinno), //7
new SqlParameter("@Vndr_Addr1", vendor.Vndr_Addr1), //8
new SqlParameter("@Vndr_Gps_Pos", "0"), //10
new SqlParameter("@Vndr_Lanline_Nos", vendor.Vndr_Lanline_Nos), //11
new SqlParameter("@Vndr_Mobile_Nos", vendor.Vndr_Mobile_Nos), //12
new SqlParameter("@Vndr_Overview", "0"), //13
new SqlParameter("@Vndr_created_on", dt), //14
new SqlParameter("@Vndr_Activated_on", dt), //15
new SqlParameter("@Vndr_Commercial_Estab_Flag", flag), //16
new SqlParameter("@Vndr_Verfied_By", LMK), //17
new SqlParameter("@Vndr_Verfied_on", dt), //18
new SqlParameter("@Vndr_Approved_By", LMK), //19
new SqlParameter("@Vndr_Approved_on", dt), //20
new SqlParameter("@Vndr_Active_Flag", flag), //21
new SqlParameter("@Vndr_Contact_person", vendor.Vndr_Contact_person), //23
new SqlParameter("@Vndr_Contact_Email", vendor.Vndr_Contact_Email), //24
new SqlParameter("@Vndr_Contact_Nos", vendor.Vndr_Contact_Nos), //25
new SqlParameter("@Vndr_Alternate_person", vendor.Vndr_Alternate_person), //26
new SqlParameter("@Vndr_Alternate_Email", vendor.Vndr_Alternate_Email), //27
new SqlParameter("@Vndr_Alternate_Nos", vendor.Vndr_Alternate_Nos), //28
new SqlParameter("@Image_Name", "ZXZ"), //29
new SqlParameter("@Image_dir", vendorBo.Image_dir), //30
new SqlParameter("@Image_Created_on", DateTime.Now), //31
new SqlParameter("@Vndr_Contact_Mobile", vendor.Vndr_Contact_Mobile), //28
new SqlParameter("@Vndr_Contact_Designation", vendor.Vndr_Contact_Designation), //28
new SqlParameter("@Vndr_Alternate_Mobile", vendor.Vndr_Alternate_Mobile), //28
new SqlParameter("@Vndr_Alternate_Designation", vendor.Vndr_Alternate_Designation), //28
new SqlParameter("@UserProfile_Id", vendor.UserProfile_Id), //28
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddVendorDetails", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[0].Value.ToString();
transactionStatus.Id = Convert.ToInt32(test);
return(transactionStatus);
#endregion
}
