public static Hashtable savedetailswithlist(Hashtable ht, string Type, string Req, List <LoadList> LoadList)
{
string Data = "";
string obj = "";
Hashtable ht_param = new Hashtable();
Hashtable ReturnData = new Hashtable();
DBFunctions db = new DBFunctions();
DataSet ds = new DataSet();
DataSet ds12 = new DataSet();
DataTable dt_LoadList = new DataTable();
List <ErrorModel> _ErrorDetails = new List <ErrorModel>();
ReturnData.Clear();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
try
{
if (Type == "SaveCompleteLoad")
{
_UserSaveModelWithID.Clear();
ht_param.Clear();
dt_LoadList = SaveParameters_LoadList(LoadList);
ht_param.Add("@ITEM_IDS", dt_LoadList);
ht_param.Add("@MEMEBER_ID", ht["MEMEBER_ID"].ToString());
ht_param.Add("@TOTAL_SVP", ht["TOTAL_SVP"].ToString());
ht_param.Add("@TOTAL_AMOUNT", ht["TOTAL_AMOUNT"].ToString());
ht_param.Add("@ORDER_TYPE", ht["ORDER_TYPE"].ToString());
ht_param.Add("@IsActive", ht["IsActive"].ToString());
ht_param.Add("@Company_ID", HttpContext.Current.Session["Company_ID"].ToString());
ht_param.Add("@Branch_ID", HttpContext.Current.Session["Branch_ID"].ToString());
ht_param.Add("@Login_user_ID", HttpContext.Current.Session["Login_user_ID"].ToString());
ds = db.SysFetchDataInDataSet("[SAVE_UPDATE_ORDER_ENTRY]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
UserSaveModelWithID _UserSaveModelWithIDDetails = new UserSaveModelWithID();
_UserSaveModelWithIDDetails.ID = item["ID"].ToString();
_UserSaveModelWithIDDetails.CustomErrorState = item["CustomErrorState"].ToString();
_UserSaveModelWithIDDetails.CustomMessage = item["CustomMessage"].ToString();
_UserSaveModelWithID.Add(_UserSaveModelWithIDDetails);
}
}
ReturnData["Save"] = serializer.Serialize(_UserSaveModelWithID);
}
ErrorModel _error = new ErrorModel();
_error.Error = "false";
_error.ErrorMessage = "Success";
_ErrorDetails.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_ErrorDetails);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "200");
}
catch (Exception ex)
{
ErrorModel _error = new ErrorModel();
_error.Error = "true";
_error.ErrorMessage = "Some problem occurred please try again later";//ex.ToString();
_ErrorDetails.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_ErrorDetails);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "500");
}
return(ReturnData);
}
public static Hashtable SaveOrderPaymentDetailsList(Hashtable ht, string Type, string Req, List <OrderPaymentDetailsList_Model> OrderPaymentDetailsList)
{
string Data = "";
string obj = "";
Hashtable ht_Blank = new Hashtable();
Hashtable ReturnData = new Hashtable();
DBFunctions db = new DBFunctions();
DataTable dt = new DataTable();
DataTable dt_OrderPaymentDetails = new DataTable();
List <ErrorModel> _ErrorDetails = new List <ErrorModel>();
ReturnData.Clear();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
try
{
if (Type == "OrderPaymentDetails")
{
_UserSaveModelWithID.Clear();
ht_param.Clear();
dt_OrderPaymentDetails = SaveParameters_OrderPaymentDetailsList(OrderPaymentDetailsList);
ht_param.Add("@UDT_ORDER_PAYMENT_DETAILS", dt_OrderPaymentDetails);
ht_param.Add("@Order_Details_id", ht["Order_Details_id"].ToString());
ds = db.SysFetchDataInDataSet("[SAVE_ORDER_PAYMENT_DETAILS]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
UserSaveModelWithID _UserSaveModelIDDetails = new UserSaveModelWithID();
_UserSaveModelIDDetails.ID = item["ID"].ToString();
_UserSaveModelIDDetails.CustomErrorState = item["CustomErrorState"].ToString();
_UserSaveModelIDDetails.CustomMessage = item["CustomMessage"].ToString();
_UserSaveModelWithID.Add(_UserSaveModelIDDetails);
}
}
ReturnData["OrderPaymentDetails"] = serializer.Serialize(_UserSaveModelWithID);
}
ErrorModel _error = new ErrorModel();
_error.Error = "false";
_error.ErrorMessage = "Success";
_ErrorDetails.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_ErrorDetails);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "200");
}
catch (Exception ex)
{
ErrorModel _error = new ErrorModel();
_error.Error = "true";
_error.ErrorMessage = "Some problem occurred please try again later";//ex.ToString();
_ErrorDetails.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_ErrorDetails);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "500");
}
return(ReturnData);
}
public static Hashtable ContactDetails(Hashtable ht, string Type, string Req)
{
try
{
string[] words = null;
string Data = Req;
ReturnData.Clear();
if (Type == "Fill")
{
_CountryModel.Clear();
ht_param.Clear();
ds = db.SysFetchDataInDataSet("[GetCountryList]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
CountryModel CountryModel_Detail = new CountryModel();
CountryModel_Detail.Name = item["NAME"].ToString();
CountryModel_Detail.COUNTRY_ID = Convert.ToInt32(item["COUNTRY_ID"].ToString());
_CountryModel.Add(CountryModel_Detail);
}
}
ReturnData["Country"] = serializer.Serialize(_CountryModel);
}
if (Type == "Wallet_Balance")
{
_Wallet_balanceModel.Clear();
ht_param.Clear();
ht_param.Add("@Member_id", ht["Member_id"].ToString());
ds = db.SysFetchDataInDataSet("[GET_MEMBER_WALLET_BALANCE_FromMemberID]", ht_param);
if (ds.Tables.Count > 0)
{
_Wallet_balanceModel = ds.Tables[0].AsEnumerable()
.Select(row => new Wallet_balanceModel
{
Wallet_Balance = row["Wallet_Balance"].ToString()
}).ToList();
}
ReturnData["Wallet_Balance"] = serializer.Serialize(_Wallet_balanceModel);
}
if (Type == "State")
{
_CountryModel.Clear();
ht_param.Clear();
ht_param.Add("@COUNTRY_ID", ht["COUNTRY_ID"].ToString());
ds = db.SysFetchDataInDataSet("[GetStateList]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
CountryModel CountryModel_Detail = new CountryModel();
CountryModel_Detail.Name = item["NAME"].ToString();
CountryModel_Detail.COUNTRY_ID = Convert.ToInt32(item["LOCATION_ID"].ToString());
_CountryModel.Add(CountryModel_Detail);
}
}
ReturnData["State"] = serializer.Serialize(_CountryModel);
}
if (Type == "District")
{
_CountryModel.Clear();
ht_param.Clear();
ht_param.Add("@State_ID", ht["State_ID"].ToString());
ds = db.SysFetchDataInDataSet("[GetDistrictList]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
CountryModel CountryModel_Detail = new CountryModel();
CountryModel_Detail.Name = item["NAME"].ToString();
CountryModel_Detail.COUNTRY_ID = Convert.ToInt32(item["District_ID"].ToString());
_CountryModel.Add(CountryModel_Detail);
}
}
ReturnData["District"] = serializer.Serialize(_CountryModel);
}
if (Type == "FillShippingAddress")
{
ShippingAddressModel_list.Clear();
ht_param.Clear();
ht_param.Add("@Company_ID", HttpContext.Current.Session["Company_ID"].ToString());
ht_param.Add("@Branch_ID", HttpContext.Current.Session["Branch_ID"].ToString());
ht_param.Add("@Contact_id", ht["Contact_id"].ToString());
ds = db.SysFetchDataInDataSet("[GetShipping_Address]", ht_param);
if (ds.Tables.Count > 0)
{
ShippingAddressModel_list = ds.Tables[0].AsEnumerable()
.Select(row => new ShippingAddressModel
{
id = row["id"].ToString(),
name = row["name"].ToString(),
addressline = row["addressline"].ToString(),
District_Name = row["District_Name"].ToString(),
State_Name = row["State_Name"].ToString(),
Country_Name = row["Country_Name"].ToString(),
pincode = row["pincode"].ToString(),
MobileNo = row["MobileNo"].ToString(),
is_default = row["is_default"].ToString()
}).ToList();
}
ReturnData["FillShippingAddress"] = serializer.Serialize(ShippingAddressModel_list);
}
if (Type == "FillShippingMethod")
{
ShippingMethodModel_list.Clear();
ht_param.Clear();
ht_param.Add("@Company_ID", HttpContext.Current.Session["Company_ID"].ToString());
ht_param.Add("@Branch_ID", HttpContext.Current.Session["Branch_ID"].ToString());
ds = db.SysFetchDataInDataSet("[GET_SHIPPING_METHOD]", ht_param);
if (ds.Tables.Count > 0)
{
ShippingMethodModel_list = ds.Tables[0].AsEnumerable()
.Select(row => new ShippingMethodModel
{
ID = row["ID"].ToString(),
NAME = row["NAME"].ToString(),
CODE = row["CODE"].ToString(),
IsActive = row["IsActive"].ToString()
}).ToList();
}
ReturnData["FillShippingMethod"] = serializer.Serialize(ShippingMethodModel_list);
}
if (Type == "SaveAddress")
{
_UserSaveModelWithID.Clear();
ht_param.Clear();
ht_param.Add("@Contact_ID", ht["Contact_ID"].ToString());
ht_param.Add("@Name", ht["Name"].ToString());
ht_param.Add("@MobileNo", ht["MobileNo"].ToString());
if (ht["country_id"].ToString() == "")
{
ht_param.Add("@country_id", DBNull.Value);
}
else
{
ht_param.Add("@country_id", ht["country_id"].ToString());
}
if (ht["state_id"].ToString() == "")
{
ht_param.Add("@state_id", DBNull.Value);
}
else
{
ht_param.Add("@state_id", ht["state_id"].ToString());
}
if (ht["district_id"].ToString() == "")
{
ht_param.Add("@district_id", DBNull.Value);
}
else
{
ht_param.Add("@district_id", ht["district_id"].ToString());
}
ht_param.Add("@addressline", ht["addressline"].ToString());
ht_param.Add("@pincode", ht["pincode"].ToString());
ht_param.Add("@city", ht["city"].ToString());
ht_param.Add("@Company_ID", HttpContext.Current.Session["Company_ID"].ToString());
ht_param.Add("@Branch_ID", HttpContext.Current.Session["Branch_ID"].ToString());
ht_param.Add("@Login_user_ID", HttpContext.Current.Session["Login_user_ID"].ToString());
ds = db.SysFetchDataInDataSet("[INSERT_Delivery_Address]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
UserSaveModelWithID ___UserSaveModelWithIDDetails = new UserSaveModelWithID();
___UserSaveModelWithIDDetails.CustomErrorState = item["CustomErrorState"].ToString();
___UserSaveModelWithIDDetails.CustomMessage = item["CustomMessage"].ToString();
___UserSaveModelWithIDDetails.ID = item["ID"].ToString();
_UserSaveModelWithID.Add(___UserSaveModelWithIDDetails);
}
}
ReturnData["SaveAddress"] = serializer.Serialize(_UserSaveModelWithID);
}
if (Type == "SaveOrder_Details")
{
_UserSaveModelWithID.Clear();
ht_param.Clear();
ht_param.Add("@Member_Id", ht["Member_Id"].ToString());
ht_param.Add("@Order_ID", ht["Order_ID"].ToString());
ht_param.Add("@ShippingMethod_ID", ht["ShippingMethod_ID"].ToString());
ht_param.Add("@Address_ID", ht["Address_ID"].ToString());
ht_param.Add("@Company_ID", HttpContext.Current.Session["Company_ID"].ToString());
ht_param.Add("@Branch_ID", HttpContext.Current.Session["Branch_ID"].ToString());
ht_param.Add("@Login_user_ID", HttpContext.Current.Session["Login_user_ID"].ToString());
ds = db.SysFetchDataInDataSet("[INSERT_Order_Details]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
UserSaveModelWithID ___UserSaveModelWithIDDetails = new UserSaveModelWithID();
___UserSaveModelWithIDDetails.CustomErrorState = item["CustomErrorState"].ToString();
___UserSaveModelWithIDDetails.CustomMessage = item["CustomMessage"].ToString();
___UserSaveModelWithIDDetails.ID = item["ID"].ToString();
_UserSaveModelWithID.Add(___UserSaveModelWithIDDetails);
}
}
ReturnData["SaveOrder_Details"] = serializer.Serialize(_UserSaveModelWithID);
}
_errorDetail.Clear();
ErrorModel _error = new ErrorModel();
_error.Error = "false";
_error.ErrorMessage = "Success";
_errorDetail.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_errorDetail);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "200");
}
catch (Exception ex)
{
_errorDetail.Clear();
ErrorModel _error = new ErrorModel();
_error.Error = "true";
_error.ErrorMessage = "Some problem occurred please try again later";
_errorDetail.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_errorDetail);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "500");
}
return(ReturnData);
}
public static Hashtable CustomerDetails(Hashtable ht, string Type, string Req)
{
try
{
string[] words = null;
string Data = Req;
ReturnData.Clear();
if (Type == "Fill")
{
words = null;
words = Req.Split('@');
for (int m = 0; words.Count() > m; m++)
{
Data = words[m].ToString();
if (Data == "Country")
{
_CountryModel.Clear();
ht_param.Clear();
ds = db.SysFetchDataInDataSet("[GetCountryList]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
CountryModel CountryModel_Detail = new CountryModel();
CountryModel_Detail.Name = item["NAME"].ToString();
CountryModel_Detail.COUNTRY_ID = Convert.ToInt32(item["COUNTRY_ID"].ToString());
_CountryModel.Add(CountryModel_Detail);
}
}
ReturnData["Country"] = serializer.Serialize(_CountryModel);
GetStateforDefaultCountry(_CountryModel[0].COUNTRY_ID.ToString());
}
if (Data == "Fill1")
{
_CountryModel.Clear();
_CustomerDetailsModel.Clear();
ht_param.Clear();
ht_param.Add("@ID", ht["ID"].ToString());
ds = db.SysFetchDataInDataSet("[GetSelectedCustomerDetails]", ht_param);
if (ds.Tables.Count > 0)
{
_CustomerDetailsModel = ds.Tables[0].AsEnumerable()
.Select(row => new CustomerDetailsModel
{
ID = row["ID"].ToString(),
Company_Name = row["Company_Name"].ToString(),
Account_Number = row["Account_Number"].ToString(),
Country = row["Country"].ToString(),
State = row["State"].ToString(),
City = row["City"].ToString(),
Zip_Code = row["Zip_Code"].ToString(),
Address1 = row["Address1"].ToString(),
Address2 = row["Address2"].ToString(),
Accnt_Payable_Email = row["Accnt_Payable_Email"].ToString(),
IsActive = row["IsActive"].ToString()
}).ToList();
}
ReturnData["BasicData"] = serializer.Serialize(_CustomerDetailsModel);
}
if (Data == "ContactDetails")
{
_CountryModel.Clear();
_TruckLocationModel.Clear();
ht_param.Clear();
ht_param.Add("@BT_ID", ht["ID"].ToString());
ht_param.Add("@Company_ID", HttpContext.Current.Session["Company_ID"].ToString());
ht_param.Add("@Branch_ID", HttpContext.Current.Session["Branch_ID"].ToString());
ds = db.SysFetchDataInDataSet("[GET_CUSTOMER_DETAILS_Contact]", ht_param);
if (ds.Tables.Count > 0)
{
_TruckLocationModel = ds.Tables[0].AsEnumerable()
.Select(row => new CustomerContactDetailsModel
{
ID = row["ID"].ToString(),
Contact_Name = row["Contact_Name"].ToString(),
Designation = row["Designation"].ToString(),
Email = row["Email"].ToString(),
Phone = row["Phone"].ToString(),
Fax = row["Fax"].ToString()
}).ToList();
}
ReturnData["ContactDetails"] = serializer.Serialize(_TruckLocationModel);
}
}
}
if (Type == "State")
{
_CountryModel.Clear();
ht_param.Clear();
ht_param.Add("@COUNTRY_ID", ht["COUNTRY_ID"].ToString());
ds = db.SysFetchDataInDataSet("[GetStateList]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
CountryModel CountryModel_Detail = new CountryModel();
CountryModel_Detail.Name = item["NAME"].ToString();
CountryModel_Detail.COUNTRY_ID = Convert.ToInt32(item["LOCATION_ID"].ToString());
_CountryModel.Add(CountryModel_Detail);
}
}
ReturnData["State"] = serializer.Serialize(_CountryModel);
}
if (Type == "Save")
{
_UserSaveModelWithID.Clear();
ht_param.Clear();
ht_param.Add("@ID", ht["ID"]);
ht_param.Add("@Company_Name", ht["Company_Name"]);
ht_param.Add("@Account_Number", ht["Account_Number"]);
if (ht["Country"].ToString() == "")
{
ht_param.Add("@Country", DBNull.Value);
}
else
{
ht_param.Add("@Country", ht["Country"].ToString());
}
if (ht["State"].ToString() == "")
{
ht_param.Add("@State", DBNull.Value);
}
else
{
ht_param.Add("@State", ht["State"].ToString());
}
ht_param.Add("@City", ht["City"].ToString());
ht_param.Add("@Zip_Code", ht["Zip_Code"].ToString());
ht_param.Add("@Address1", ht["Address1"].ToString());
ht_param.Add("@Address2", ht["Address2"].ToString());
ht_param.Add("@Accnt_Payable_Email", ht["Accnt_Payable_Email"].ToString());
ht_param.Add("@ContactID", ht["ContactID"].ToString());
ht_param.Add("@ContactName", ht["ContactName"].ToString());
ht_param.Add("@Designation", ht["Designation"].ToString());
ht_param.Add("@ContactEmail", ht["ContactEmail"].ToString());
ht_param.Add("@ContactPhoneNo", ht["ContactPhoneNo"].ToString());
ht_param.Add("@ContactFax", ht["ContactFax"].ToString());
ht_param.Add("@Mode", ht["MODE"].ToString());
ht_param.Add("@Company_ID", HttpContext.Current.Session["Company_ID"].ToString());
ht_param.Add("@Branch_ID", HttpContext.Current.Session["Branch_ID"].ToString());
ht_param.Add("@Login_user_ID", HttpContext.Current.Session["Login_user_ID"].ToString());
ds = db.SysFetchDataInDataSet("[INSERT_CUSTOMER_DETAILS_Basic]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
UserSaveModelWithID _UserSaveModelIDDetails = new UserSaveModelWithID();
_UserSaveModelIDDetails.ID = item["ID"].ToString();
_UserSaveModelIDDetails.CustomErrorState = item["CustomErrorState"].ToString();
_UserSaveModelIDDetails.CustomMessage = item["CustomMessage"].ToString();
_UserSaveModelWithID.Add(_UserSaveModelIDDetails);
}
}
ReturnData["Save"] = serializer.Serialize(_UserSaveModelWithID);
}
if (Type == "Delete")
{
_UserSaveModel.Clear();
ht_param.Clear();
ht_param.Add("@ID", ht["ID"]);
ht_param.Add("@MODE", "DELETE");
ht_param.Add("@Login_user_ID", HttpContext.Current.Session["Login_user_ID"].ToString());
ds = db.SysFetchDataInDataSet("[INSERT_CUSTOMER_DETAILS_Contact]", ht_param);
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
UserSaveModel _UserSaveModelDetails = new UserSaveModel();
_UserSaveModelDetails.CustomErrorState = item["CustomErrorState"].ToString();
_UserSaveModelDetails.CustomMessage = item["CustomMessage"].ToString();
_UserSaveModel.Add(_UserSaveModelDetails);
}
}
ReturnData["Delete"] = serializer.Serialize(_UserSaveModel);
}
_ErrorModel.Clear();
ErrorModel _error = new ErrorModel();
_error.Error = "false";
_error.ErrorMessage = "sucess";
_ErrorModel.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_ErrorModel);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "200");
}
catch (Exception ex)
{
_ErrorModel.Clear();
ReturnData.Clear();
ErrorModel _error = new ErrorModel();
_error.Error = "true";
_error.ErrorMessage = "Some problem occurred please try again later";
_ErrorModel.Add(_error);
ReturnData["ErrorDetail"] = serializer.Serialize(_ErrorModel);
HttpContext.Current.Response.AppendHeader("ResponseHeader", "500");
}
return(ReturnData);
}
