public DataTable GetPost_Load_Inquiry(ref IDbDataAdapter adapter, String load_inquiry_no, ref String Message)
{
try
{
adapter.SelectCommand.Parameters.Clear();
StringBuilder SQLSelect = new StringBuilder();
SQLSelect.Append(@"SELECT * FROM post_load_inquiry WHERE load_inquiry_no=@load_inquiry_no ");
adapter.SelectCommand.CommandText = SQLSelect.ToString();
adapter.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("load_inquiry_no", DbType.String, load_inquiry_no));
adapter.TableMappings.Clear();
adapter.TableMappings.Add("Table", "post_load_inquiry");
DataSet ds = new DataSet();
adapter.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Message = "Post Load Inquiry data retrieved successfully ";
return(ds.Tables[0]);
}
else
{
Message = "Post Load Inquiry data Not Found ";
return(null);
}
}
catch (Exception ex)
{
ServerLog.MgmtExceptionLog(ex.Message + Environment.NewLine + ex.StackTrace);
Message = ex.Message;
return(null);
}
}
public Decimal GetPackingRate(String Packing_type_code, DateTime OrderDate, ref Decimal RatePerSizeTypeCode, ref String Message)
{
try
{
DBDataAdpterObject.SelectCommand.Parameters.Clear();
StringBuilder SQLSelect = new StringBuilder();
SQLSelect.Append(@"SELECT * FROM PackingRateDetail
WHERE Packing_type_code = @Packing_type_code
AND (start_date <= @OrderDate) AND (end_date IS NULL OR end_date >= @OrderDate)");
DBDataAdpterObject.SelectCommand.CommandText = SQLSelect.ToString();
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@Packing_type_code", DbType.String, Packing_type_code));
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@OrderDate", DbType.DateTime, OrderDate));
DBDataAdpterObject.TableMappings.Clear();
DBDataAdpterObject.TableMappings.Add("Table", "PackingRateDetail");
DataSet ds = new DataSet();
DBDataAdpterObject.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Message = "Packing Rate detail data retrieved successfully for Packing_type_code : " + Packing_type_code;
RatePerSizeTypeCode = Convert.ToDecimal(ds.Tables[0].Rows[0]["rate"]);
return(RatePerSizeTypeCode);
}
else
{
Message = "Packing Rate detail data is not found for Packing_type_code : " + Packing_type_code;
return(-1);
}
}
catch (Exception ex)
{
ServerLog.MgmtExceptionLog(ex.Message + Environment.NewLine + ex.StackTrace);
Message = ex.Message;
return(-1);
}
}
public string Unlock()
{
try
{
DBConnection.Open();
DBCommand.Transaction = DBConnection.BeginTransaction();
DBCommand.Transaction.Commit();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
return(BLGeneralUtil.return_ajax_string("1", "Done"));
}
catch (Exception ex)
{
DBCommand.Transaction.Rollback();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
return(BLGeneralUtil.return_ajax_string("0", ex.Message));
}
}
public Decimal GetConversionFactor(String FromUOM, String ToUOM, ref String Message)
{
try
{
DBDataAdpterObject.SelectCommand.Parameters.Clear();
StringBuilder SQLSelect = new StringBuilder();
SQLSelect.Append(@"SELECT * FROM DistanceConversion
WHERE (FromUOM = @FromUOM)
AND (ToUOM <= @ToUOM) ");
DBDataAdpterObject.SelectCommand.CommandText = SQLSelect.ToString();
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@FromUOM", DbType.String, FromUOM));
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@ToUOM", DbType.String, ToUOM));
DBDataAdpterObject.TableMappings.Clear();
DBDataAdpterObject.TableMappings.Add("Table", "DistanceConversion");
DataSet ds = new DataSet();
DBDataAdpterObject.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Message = "Conversion Factor retrieved successfully.";
return(Convert.ToDecimal(ds.Tables[0].Rows[0]["ConversionFactor"]));;
}
else
{
Message = "Fail to get Conversion Factor.";
return(-1);
}
}
catch (Exception ex)
{
ServerLog.MgmtExceptionLog(ex.Message + Environment.NewLine + ex.StackTrace);
Message = ex.Message;
return(-1);
}
}
public string GetParameter(string paramcode, string paramvalue)
{
DataTable dtPostLoadOrders = new DataTable();
String query1 = "SELECT * FROM param_mst where param_code = @parcode and param_value = @parvalue ";
DBConnection.Open();
DBDataAdpterObject.SelectCommand.Parameters.Clear();
DBDataAdpterObject.SelectCommand.CommandText = query1;
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("parcode", DbType.String, paramcode));
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("parvalue", DbType.String, paramvalue));
DataSet ds = new DataSet();
DBDataAdpterObject.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
dtPostLoadOrders = ds.Tables[0];
}
}
DBConnection.Close();
if (dtPostLoadOrders != null && dtPostLoadOrders.Rows.Count > 0)
{
return(BLGeneralUtil.return_ajax_data("1", SendReceiveJSon.GetJson(dtPostLoadOrders)));
}
else
{
return(BLGeneralUtil.return_ajax_string("0", "No Data Found"));
}
}
public DataTable GetSizeTypeDetail(String SizeTypeCode, Decimal TotalDistance, String TotalDistanceUOM, ref String Message)
{
try
{
DBDataAdpterObject.SelectCommand.Parameters.Clear();
StringBuilder SQLSelect = new StringBuilder();
SQLSelect.Append(@"SELECT SizeTypeCode, SizeTypeDesc,
TruckTypeMst.truck_type_code, truck_type_desc, NoOfTruck, 0.0000 AS MinDistance, CAST(NULL AS varchar) AS MinDistanceUOM,
DriverTypeMst.driver_type_code, driver_type_desc, NoOfDriver, 0.0000 AS RatePerDriver, 0.0000 AS TotalDriverRate,
LabourTypeMst.labour_type_code, labour_type_desc, NoOfLabour, 0.0000 AS RatePerLabour, 0.0000 AS TotalLabourRate,
HandimanTypeMst.Handiman_type_code, Handiman_type_desc, NoOfHandiman, 0.0000 AS RatePerHandiman, 0.0000 AS TotalHandimanRate,
@TotalDistance AS TotalDistance, DistanceTypeMst.distance_type_code, distance_type_desc, 0.0000 AS RatePerDistanceUOM, 0.0000 AS TotalDistanceRate,
TimeForLoadingInMinute, TimeForUnloadingInMinute, 0.0000 AS TimeToTravelInMinute, 0.0000 AS TotalTimeForPostOrder, 0.0000 AS NoOfDay, 0.0000 AS Total_cost
,SizeTypeMst.Packing_rate AS TotalPackingRate
FROM SizeTypeMst
LEFT OUTER JOIN TruckTypeMst ON SizeTypeMst.truck_type_code = TruckTypeMst.truck_type_code
LEFT OUTER JOIN DriverTypeMst ON SizeTypeMst.driver_type_code = DriverTypeMst.driver_type_code
LEFT OUTER JOIN LabourTypeMst ON SizeTypeMst.labour_type_code = LabourTypeMst.labour_type_code
LEFT OUTER JOIN HandimanTypeMst ON SizeTypeMst.Handiman_type_code = HandimanTypeMst.Handiman_type_code
CROSS JOIN DistanceTypeMst
WHERE SizeTypeCode = @SizeTypeCode
AND DistanceTypeMst.distance_type_code = @distance_type_code ");
DBDataAdpterObject.SelectCommand.CommandText = SQLSelect.ToString();
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@SizeTypeCode", DbType.String, SizeTypeCode));
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@TotalDistance", DbType.Decimal, TotalDistance));
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@distance_type_code", DbType.String, TotalDistanceUOM));
DBDataAdpterObject.TableMappings.Clear();
DBDataAdpterObject.TableMappings.Add("Table", "SizeTypeMst");
DataSet ds = new DataSet();
DBDataAdpterObject.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Message = "SizeType detail data retrieved successfully for SizeTypeCode : " + SizeTypeCode;
return(ds.Tables[0]);
}
else
{
Message = "SizeType detail data is not found for SizeTypeCode : " + SizeTypeCode;
return(null);
}
}
catch (Exception ex)
{
ServerLog.MgmtExceptionLog(ex.Message + Environment.NewLine + ex.StackTrace);
Message = ex.Message;
return(null);
}
}
public string sendmailforinvitefriend([FromBody] JObject parameter)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "call");
//JavaScriptSerializer js = new JavaScriptSerializer();
//string[] persons = js.Deserialize<string[]>(parameter["dataemail"]["email_list_send"].ToString());
emailSendFrined objsendmail = new emailSendFrined();
string result = ""; bool resultSendEmail = false;
bool security_flag = false;
try
{
if (parameter["dataemail"]["email_list_send"].ToString() != "")
{
objsendmail = parameter["dataemail"].ToObject <emailSendFrined>();
}
if (objsendmail.email_list_send != null && objsendmail.email_list_send.Length > 0)
{
for (int i = 0; i < objsendmail.email_list_send.Length; i++)
{
resultSendEmail = sendinvitemail(objsendmail.email_list_send[i]);
}
}
if (resultSendEmail == true)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Pass");
return(BLGeneralUtil.return_ajax_string("1", "Thanks for your referral"));
}
else
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "Fail");
return(BLGeneralUtil.return_ajax_string("0", "please Enter Email ID"));
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return(BLGeneralUtil.return_ajax_string("0", "some thing went wrong"));
}
//return result;
}
public string forgotpassword([FromBody] JObject parameter)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
bool flag = false;
Random rand = new Random();
int randomNo = rand.Next(1, 1000000);
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "call");
if (parameter["email_id"] == null || parameter["email_id"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "Email id not found"));
}
try
{
DataTable dt = objmasters.LoginCheck(parameter["email_id"].ToString());
if (dt == null)
{
return(BLGeneralUtil.return_ajax_string("0", "No Datails Found"));
}
else
{
flag = forgotpassword(dt.Rows[0]["email_id"].ToString(), dt.Rows[0]["university"].ToString());
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + ex.ToString() + "status" + "");
return(BLGeneralUtil.return_ajax_string("0", ex.Message));
}
if (flag == true)
{
return(BLGeneralUtil.return_ajax_string("1", "please check mail to update new password"));
}
else
{
return(BLGeneralUtil.return_ajax_string("0", "some thing went wrong"));
}
}
public DataTable GetParameter(String Parameter, String Code, ref String Message)
{
try
{
DBDataAdpterObject.SelectCommand.Parameters.Clear();
StringBuilder SQLSelect = new StringBuilder();
SQLSelect.Append("SELECT * FROM ParameterMst ");
SQLSelect.Append("WHERE 1=1 ");
if (Parameter != null && Parameter.Trim() != String.Empty)
{
SQLSelect.Append("AND (Parameter=@Parameter) ");
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@Parameter", DbType.String, Parameter));
}
if (Code != null && Code.Trim() != String.Empty)
{
SQLSelect.Append("AND (Code=@Code) ");
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@Code", DbType.String, Code));
}
DBDataAdpterObject.SelectCommand.CommandText = SQLSelect.ToString();
DBDataAdpterObject.TableMappings.Clear();
DBDataAdpterObject.TableMappings.Add("Table", "ParameterMst");
DataSet ds = new DataSet();
DBDataAdpterObject.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Message = "ParameterMst retrieved successfully.";
return(ds.Tables[0]);
}
else
{
Message = "ParameterMst not found.";
return(null);
}
}
catch (Exception ex)
{
Message = ex.Message;
ServerLog.MgmtExceptionLog(ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
}
public Byte GetTruckRate(String truck_type_code, String rate_type_flag, int NoOfTruck, Decimal NoOfDay, DateTime OrderDate, ref Decimal MinDistance, ref String MinDistanceUOM, ref String Message)
{
try
{
DBDataAdpterObject.SelectCommand.Parameters.Clear();
StringBuilder SQLSelect = new StringBuilder();
SQLSelect.Append(@"SELECT * FROM TruckRateDetail
WHERE truck_type_code = @truck_type_code
AND rate_type_flag = @rate_type_flag
AND (start_date <= @OrderDate) AND (end_date IS NULL OR end_date >= @OrderDate)");
DBDataAdpterObject.SelectCommand.CommandText = SQLSelect.ToString();
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@truck_type_code", DbType.String, truck_type_code));
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@rate_type_flag", DbType.String, rate_type_flag));
DBDataAdpterObject.SelectCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@OrderDate", DbType.DateTime, OrderDate));
DBDataAdpterObject.TableMappings.Clear();
DBDataAdpterObject.TableMappings.Add("Table", "TruckRateDetail");
DataSet ds = new DataSet();
DBDataAdpterObject.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Message = "Truck Rate detail data retrieved successfully for truck_type_code : " + truck_type_code;
MinDistance = Convert.ToDecimal(ds.Tables[0].Rows[0]["MinDistance"]);
MinDistanceUOM = ds.Tables[0].Rows[0]["MinDistanceUOM"].ToString();
return(1);
}
else
{
Message = "Truck Rate detail data is not found for truck_type_code : " + truck_type_code;
return(2);
}
}
catch (Exception ex)
{
ServerLog.MgmtExceptionLog(ex.Message + Environment.NewLine + ex.StackTrace);
Message = ex.Message;
return(2);
}
}
public string save_registrationquantina([FromBody] JObject parameter)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
bool flag = false;
Random rand = new Random();
int randomNo = rand.Next(1, 1000000);
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "call");
if (parameter["university"] == null || parameter["university"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "university not found"));
}
else if (parameter["email_id"] == null || parameter["email_id"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "Email id not found"));
}
else if (parameter["password"] == null || parameter["password"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "password not found"));
}
else if (parameter["app_name"] == null || parameter["app_name"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "app name not found"));
}
//check if exites user
DataTable user = objmasters.ismemberexits(parameter["email_id"].ToString().ToLower());
if (user != null && user.Rows.Count > 0)
{
return(BLGeneralUtil.return_ajax_string("0", "this email Id is already registered "));
}
try
{
DS_General.member_masterRow objmember_maste = objgeneral.member_master.Newmember_masterRow();
objmember_maste.member_code = "1";
objmember_maste.app_name = parameter["app_name"].ToString();
objmember_maste.university = parameter["university"].ToString();
objmember_maste.first_name = parameter["name"].ToString();
objmember_maste.email_id = parameter["email_id"].ToString().ToLower();
EncryptPassword encrpt = new EncryptPassword();
string encrpt_password = encrpt.Encrypt(parameter["password"].ToString());
objmember_maste.email_rand_no = randomNo;
objmember_maste.password = encrpt_password;
objmember_maste.is_active = "N";
objmember_maste.is_quantina = "Y";
objmember_maste.created_by = parameter["email_id"].ToString();
objmember_maste.created_date = System.DateTime.Now;
objmember_maste.created_host = HttpContext.Current.Request.UserHostName;
string BlobId = DoUserRegistrationQuickBlox(parameter["name"].ToString(), parameter["email_id"].ToString(), "admin@123");
if (BlobId == null || BlobId == "")
{
return(BLGeneralUtil.return_ajax_string("0", "some thing went wrong"));
}
else
{
objmember_maste.BlobId = BlobId;
objgeneral.member_master.Addmember_masterRow(objmember_maste);
}
DS_Transtration.fn_token_balanceRow token_bal_row = objDs_trastration.fn_token_balance.Newfn_token_balanceRow();
token_bal_row.doc_no = "1";
token_bal_row.member_id = parameter["email_id"].ToString().ToLower();
token_bal_row.total_debit = Convert.ToInt16(0.0);
token_bal_row.total_credit = Convert.ToInt16(0.0);
token_bal_row.balance_token = Convert.ToInt16(0.0);
token_bal_row.balance_amount = Convert.ToInt16(0.0);
token_bal_row.is_active = "Y";
token_bal_row.created_by = parameter["email_id"].ToString().ToLower();
token_bal_row.created_date = System.DateTime.Now;
token_bal_row.created_host = HttpContext.Current.Request.UserHostName;
objDs_trastration.fn_token_balance.Addfn_token_balanceRow(token_bal_row);
objBLReturnObject = objmasters.save_regstration(objgeneral, objDs_trastration);
if (objBLReturnObject.ExecutionStatus == 1)
{
try
{
// bool resultSendEmail = false;
bool resultSendEmail = profliecreationsendEmail(parameter["email_id"].ToString(), parameter["name"].ToString(), randomNo, parameter["university"].ToString(), "");
if (resultSendEmail == true)
{
flag = true;
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return(BLGeneralUtil.return_ajax_string("0", ex.ToString()));
}
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return(BLGeneralUtil.return_ajax_string("0", ex.ToString()));
}
if (flag == true)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "1");
return(BLGeneralUtil.return_ajax_string("1", "Thanks for signing up! Please click on the link sent to your email to confirm your account"));
}
else
{
return(BLGeneralUtil.return_ajax_string("0", "some things goes to wrong"));
}
}
public string logincheck([FromBody] JObject parameter)
{
BLReturnObject objBLReturnObject = new BLReturnObject();
bool flag = false;
Random rand = new Random();
int randomNo = rand.Next(1, 1000000);
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "call");
if (parameter["email_id"] == null || parameter["email_id"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "Email id not found"));
}
else if (parameter["password"] == null || parameter["password"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "password not found"));
}
else if (parameter["app_name"] == null || parameter["app_name"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "app name not found"));
}
try
{
EncryptPassword encrpt = new EncryptPassword();
string encrpt_password = encrpt.Encrypt(parameter["password"].ToString());
//check
DataTable user = objmasters.ismemberexits(parameter["email_id"].ToString().ToLower());
if (user == null || user.Rows.Count < 0)
{
return(BLGeneralUtil.return_ajax_string("0", "this email Id is not registered "));
}
if (user.Rows[0]["email_rand_no"].ToString() != "0")
{
return(BLGeneralUtil.return_ajax_string("0", "This email ID has not yet been confirmed "));
}
else if (user.Rows[0]["is_quantina"].ToString() == null || user.Rows[0]["is_quantina"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "this email Id is not allowed in this app "));
}
else if (user.Rows[0]["BlobId"].ToString() == null || user.Rows[0]["BlobId"].ToString() == "")
{
return(BLGeneralUtil.return_ajax_string("0", "Blob ID not Found "));
}
else if (user.Rows[0]["password"].ToString() != encrpt_password)
{
return(BLGeneralUtil.return_ajax_string("0", " password is wrong"));
}
else if (user.Rows[0]["password"].ToString() == encrpt_password)
{
if (user.Rows[0]["is_quantina"].ToString() == "Y")
{
return(BLGeneralUtil.return_ajax_data("1", GetJson1(user)));
}
}
else
{
}
}
catch (Exception ex)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + ex.StackTrace);
return(BLGeneralUtil.return_ajax_string("0", ex.ToString()));
}
if (flag == true)
{
ServerLog.Log_QUA((System.Web.HttpContext.Current.Request.AppRelativeCurrentExecutionFilePath).ToString() + " " + parameter.ToString() + "status" + "1");
return(BLGeneralUtil.return_ajax_string("1", "saved successfully"));
}
else
{
return(BLGeneralUtil.return_ajax_string("0", "some things goes to wrong"));
}
}
public string SaveAppLog([FromBody] JObject jobj)
{
AppLog jobjdata = new AppLog();
Document doc = new Document();
BLReturnObject objBLReturnObject = new BLReturnObject(); Master master = new Master();
string message = "";
DS_AppLog ds_app = new DS_AppLog();
List <AppLog> tload = new List <AppLog>();
tload = jobj["log"].ToObject <List <AppLog> >();
DataTable dt_log = new DataTable(); string LogDocID = "";
dt_log = BLGeneralUtil.ToDataTable(tload);
try
{
if (jobj != null)
{
if (dt_log != null && dt_log.Rows.Count > 0)
{
DBConnection.Open();
DBCommand.Transaction = DBConnection.BeginTransaction();
ds_app.EnforceConstraints = false;
if (!doc.W_GetNextDocumentNo(ref DBCommand, "APL", "", "", ref LogDocID, ref message)) // New Driver Notification ID
{
return(BLGeneralUtil.return_ajax_string("0", message));
}
ds_app.AppLog.ImportRow(dt_log.Rows[0]);
ds_app.AppLog[0].log_id = LogDocID;
ds_app.AppLog[0].log_date = System.DateTime.UtcNow;
ds_app.AppLog[0].created_date = System.DateTime.UtcNow;
ds_app.AppLog[0].AcceptChanges();
ds_app.AppLog[0].SetAdded();
ds_app.EnforceConstraints = true;
objBLReturnObject = master.UpdateTables(ds_app.AppLog, ref DBCommand);
if (objBLReturnObject.ExecutionStatus != 1)
{
ServerLog.Log(objBLReturnObject.ServerMessage.ToString());
DBCommand.Transaction.Rollback();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
return(BLGeneralUtil.return_ajax_string("0", objBLReturnObject.ServerMessage));
}
DBCommand.Transaction.Commit();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
objBLReturnObject.ExecutionStatus = 1;
ServerLog.SuccessLog("App Log Entry Saved : " + LogDocID);
}
}
}
catch (Exception ex)
{
ServerLog.Log(ex.Message + ex.StackTrace);
DBCommand.Transaction.Rollback();
if (DBConnection.State == ConnectionState.Open)
{
DBConnection.Close();
}
return(BLGeneralUtil.return_ajax_string("0", ex.Message));
}
return(BLGeneralUtil.return_ajax_string("1", "App Log Entry Saved : " + LogDocID));
}
public bool SetAndModifyStatusinAnyTableNew(string tablename, string status, string shipperid, string inquiryno, string ownerid, string truckid, string driverid, ref IDbCommand DBCommand)
{
DBCommand.Parameters.Clear();
string where = "";
string query = " UPDATE " + tablename +
" SET status = '" + status + "' " + " WHERE ";
if (shipperid != string.Empty && shipperid != "" && shipperid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@shipperid", DbType.String, shipperid));
where = " shipper_id= @shipperid ";
}
if (inquiryno != string.Empty && inquiryno != "" && inquiryno.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@inquiryno", DbType.String, inquiryno));
if (where != string.Empty)
{
where = where + "AND load_inquiry_no= @inquiryno ";
}
else
{
where = " load_inquiry_no = @inquiryno ";
}
}
if (ownerid != string.Empty && ownerid != "" && ownerid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@ownerid", DbType.String, ownerid));
if (where != string.Empty)
{
where = where + "AND owner_id= @ownerid ";
}
else
{
where = " owner_id = @ownerid ";
}
}
if (truckid != string.Empty && truckid != "" && truckid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@truckid", DbType.String, truckid));
if (where != string.Empty)
{
where = where + "AND truck_id= @truckid ";
}
else
{
where = " truck_id = @truckid ";
}
}
if (driverid != string.Empty && driverid != "" && driverid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@driverid", DbType.String, driverid));
if (where != string.Empty)
{
where = where + "AND driver_id= @driverid ";
}
else
{
where = " driver_id = @driverid ";
}
}
query = query + where;
DBCommand.CommandText = query;
int row_count = 0;
if (DBConnection.State == ConnectionState.Closed)
{
DBConnection.Open();
}
try
{
row_count = DBCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
ServerLog.Log(ex.Message + Environment.NewLine + ex.StackTrace);
return(false);
}
if (row_count <= 0)
{
ServerLog.Log("Status not Updated " + tablename + Environment.NewLine + query);
return(false);
}
else
{
return(true);
}
}
public DataTable GetTableDataCommonMethod(string tablename, string status, string shipperid, string inquiryno, string ownerid, string truckid, string driverid, ref IDbCommand DBCommand)
{
DBCommand.Parameters.Clear();
string where = "";
string query = "select * from " + tablename + " WHERE ";
if (shipperid != string.Empty && shipperid != "" && shipperid.TrimEnd() != null)
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@shipperid", DbType.String, shipperid.TrimEnd()));
where = " shipper_id= @shipperid ";
}
if (inquiryno != string.Empty && inquiryno != "" && inquiryno.TrimEnd() != null)
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@inquiryno", DbType.String, inquiryno.TrimEnd()));
if (where != string.Empty)
{
where = where + "AND load_inquiry_no= @inquiryno ";
}
else
{
where = " load_inquiry_no = @inquiryno ";
}
}
if (ownerid != string.Empty && ownerid != "" && ownerid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@ownerid", DbType.String, ownerid.TrimEnd()));
if (where != string.Empty)
{
where = where + "AND owner_id= @ownerid ";
}
else
{
where = " owner_id = @ownerid ";
}
}
if (truckid != string.Empty && truckid != "" && truckid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@truckid", DbType.String, truckid.TrimEnd()));
if (where != string.Empty)
{
where = where + "AND truck_id= @truckid ";
}
else
{
where = " truck_id = @truckid ";
}
}
if (driverid != string.Empty && driverid != "" && driverid.TrimEnd() != "")
{
DBCommand.Parameters.Add(BLGeneralUtil.MakeParameter("@driverid", DbType.String, driverid.TrimEnd()));
if (where != string.Empty)
{
where = where + "AND driver_id= @driverid ";
}
else
{
where = " driver_id = @driverid ";
}
}
query = query + where;
DBDataAdpterObject.SelectCommand.CommandText = query;
DataSet ds = new DataSet();
if (DBConnection.State == ConnectionState.Closed)
{
DBConnection.Open();
}
DBDataAdpterObject.Fill(ds);
if (ds.Tables[0] == null || ds.Tables[0].Rows.Count == 0)
{
return(null);
}
else
{
return(ds.Tables[0]);
}
}
