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]); } }