public MessageModel Save(ManualBookingTrackModel MbtModel, string CompanyCode) { MessageModel objMessage = new MessageModel(); string conString = CompanyConfigService.getDbCredentials(CompanyCode); SqlDataAceessLayer _dal = new SqlDataAceessLayer(conString); string Query = @"INSERT INTO Domestic.Trn_Vehicle_Tracking (Vehicle_ID,Trip_ID,Booking_ID,Manual_Booking_ID,Tracking_Date,Location, Tracking_Time,Remarks,Reason_ID,KMs) Select 0,0,0," + MbtModel.ManualBookingId.ToString() + ",'" + MbtModel.TrackingDate.ToString("yyyy-MM-dd") + "','" + MbtModel.Location + "','" + MbtModel.TrackingDate.ToString("HH:mm") + "','" + MbtModel.Remark + "'," + MbtModel.ReasonId + ",0"; try { DataSet Ds = _dal.ExecuteSql(Query); objMessage.MessageId = 0; objMessage.Message = "Save Sucessfully"; } catch (Exception ex) { objMessage.MessageId = 1; objMessage.Message = ex.Message; } return(objMessage); }
public MessageModel Save(ManualBookingModel BookingModel, string CompanyCode, int UserId) { string conString = CompanyConfigService.getDbCredentials(CompanyCode); MessageModel objMessage = new MessageModel(); SqlDataAceessLayer _dal = new SqlDataAceessLayer(conString); int YearCode = CompanyConfigService.getYearCode(BookingModel.BookingDate); string Query = @"INSERT INTO [Custom].[Trn_Booking_Manual] (Year_Code,LR_No,LR_Date,From_Service_Network_ID,From_Service_Network,To_Service_Network_ID, To_Service_Network,Vehicle_ID,Vehicle_No,Customer_ID,Customer_Name,Weight,NoOfArticles,Is_Active, Created_On,Created_By,Updated_On,Updated_By,Attachment_Path) Select " + YearCode.ToString() + ",'" + BookingModel.BookingNo + "','" + BookingModel.BookingDate + "'," + BookingModel.FromLocationId + ",'" + BookingModel.FromLocation + "'," + BookingModel.ToLocationId + ",'" + BookingModel.ToLocation + "'," + BookingModel.VehicleId + ",'" + BookingModel.VechicleNo + "'," + BookingModel.CustomerId + ",'" + BookingModel.CustomerName + "'," + BookingModel.BookingWeight + "," + BookingModel.BookingNoOfPackages + ",1,getdate()," + UserId + ",getdate()," + UserId + ",'" + BookingModel.AttachmentPath + "'" + "; Select 1 "; try { DataSet Ds = _dal.ExecuteSql(Query); objMessage.MessageId = 0; objMessage.Message = "Save Sucessfully"; } catch (Exception ex) { objMessage.MessageId = 1; objMessage.Message = ex.Message; } return(objMessage); }
public JObject getStatus(string CompanyCode) { string _con = CompanyConfigService.getDbCredentials(CompanyCode); ManualBookingTrackService mbtservice = new ManualBookingTrackService(); DataSet Ds = mbtservice.getStatus(_con); string json = JsonConvert.SerializeObject(Ds); JObject jobj = JObject.Parse(json); return(jobj); }
public JObject getConsignorConsignee(string CompanyCode, string SearchFor) { string _con = CompanyConfigService.getDbCredentials(CompanyCode); SerachServices SS = new SerachServices(); DataSet Ds = SS.getConsignorConsignee(_con, SearchFor); string json = JsonConvert.SerializeObject(Ds); JObject jobj = JObject.Parse(json); return(jobj); }
public ManualBookingModel GetByBookingNo(string BookingNo, string CompanyCode) { string conString = CompanyConfigService.getDbCredentials(CompanyCode); SqlDataAceessLayer _dal = new SqlDataAceessLayer(conString); int YearCode = CompanyConfigService.getYearCode(DateTime.Now); string Query = @"Select Booking_Manual_ID,LR_No,LR_Date,From_Service_Network,To_Service_Network,Vehicle_No,Customer_Name, Weight,NoOfArticles,Attachment_Path From Custom.Trn_Booking_Manual where Year_Code = " + YearCode.ToString() + " and LR_No = '" + BookingNo + "'"; DataSet Ds = _dal.ExecuteSql(Query); var mbm = GenerateManualBookingModel(Ds.Tables[0].Rows[0]); return(mbm); }
public ManualBookingTrackNTraceModel GetTrackDetails(int ManualBookingId, string CompanyCode) { string conString = CompanyConfigService.getDbCredentials(CompanyCode); SqlDataAceessLayer _dal = new SqlDataAceessLayer(conString); string Query = @"SELECT Tracking_Date,Tracking_Time,Location,Reason,Remarks,A.Attachment_Path,[Signature] FROM Domestic.Trn_Vehicle_Tracking A INNER JOIN Custom.Trn_Booking_Manual B ON A.Manual_Booking_ID = B.Booking_Manual_ID LEFT OUTER JOIN Common.Master_Reason C ON A.Reason_ID = C.Reason_ID where A.Manual_Booking_ID = " + ManualBookingId; DataSet Ds = _dal.ExecuteSql(Query); ManualBookingTrackNTraceModel mbm = new ManualBookingTrackNTraceModel(); mbm.TrackDs = Ds; return(mbm); }
public ActionResult ValidateUser(string CompanyCode, string Login, string Password) { string _con = CompanyConfigService.getDbCredentials(CompanyCode); MessageModel msg = new MessageModel(); if (_con.Length > 0) { AuthenticationService AS = new AuthenticationService(); msg = AS.ValidateUser(_con, Login, Password); } else { msg.MessageId = 1; msg.Message = "Invalid Login/Password."; } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public MessageModel Save(ManualBookingPODModel MbtModel, string CompanyCode) { MessageModel objMessage = new MessageModel(); string conString = CompanyConfigService.getDbCredentials(CompanyCode); SqlDataAceessLayer _dal = new SqlDataAceessLayer(conString); string Query = "Select Reason_ID,Reason from Common.Master_Reason a inner join Common.Master_Reason_Category b on " + "a.Master_Reason_Category_ID = b.Master_Reason_Category_ID where b.Master_Reason_Category='POD' "; DataSet Ds1 = _dal.ExecuteSql(Query); string ReasonId = "0"; if (Ds1.Tables[0].Rows.Count == 0) { objMessage.MessageId = 2; objMessage.Message = "POD Status Not Found"; return(objMessage); } else { ReasonId = Ds1.Tables[0].Rows[0]["Reason_ID"].ToString(); } Query = @"INSERT INTO Domestic.Trn_Vehicle_Tracking (Vehicle_ID,Trip_ID,Booking_ID,Manual_Booking_ID,Tracking_Date,Location,Tracking_Time,Remarks,Reason_ID,KMs,Attachment_Path,Signature)" + "Select 0,0,0," + MbtModel.ManualBookingID.ToString() + ",'" + MbtModel.DeliveryDateTime.ToString("yyyy-MM-dd") + "','','" + MbtModel.DeliveryDateTime.ToString("HH:mm") + "',''," + ReasonId + ",0,'" + MbtModel.AttachmentPath + "','" + MbtModel.UploadSignature1_txtSignatureValue + "'"; try { DataSet Ds = _dal.ExecuteSql(Query); objMessage.MessageId = 0; objMessage.Message = "Save Sucessfully"; } catch (Exception ex) { objMessage.MessageId = 1; objMessage.Message = ex.Message; } return(objMessage); }
public MessageModel ValidateUser(string con, string UserName, string Password) { SqlDataAceessLayer _dal = new SqlDataAceessLayer(con); int YearCode = CompanyConfigService.getYearCode(DateTime.Now); DataSet _ds = null; SqlParameter[] param = { _dal.MakeOutParams("@Error_Code", SqlDbType.Int, 0), _dal.MakeOutParams("@Error_Desc", SqlDbType.VarChar, 4000), _dal.MakeInParams("@YearCode", SqlDbType.Int, 0,YearCode), _dal.MakeInParams("@UserName", SqlDbType.VarChar, 25,UserName), _dal.MakeInParams("@Password", SqlDbType.VarChar, 25,Password), _dal.MakeInParams("@DivisionID", SqlDbType.Int, 0, 1) }; _dal.ExecuteStoredProcedure("[System].[spLogin_Check]", param, ref _ds); MessageModel objMessage = new MessageModel(); objMessage.MessageId = Convert.ToInt32(param[0].Value); objMessage.Message = Convert.ToString(param[1].Value); return(objMessage); }
public SqlDataAceessLayer() { _connectionString = CompanyConfigService.GetParameter("DBCredential"); }