public ActionResult Save(ManualBookingModel BookingModel)
{
MessageModel msg = new MessageModel();
try
{
HttpPostedFileBase Upload = Request.Files[0];
var fileName = "";
if (Request.Files[0].ContentLength > 0)
{
fileName = Path.GetFileName(Upload.FileName);
var path = Path.Combine(Server.MapPath("~/Attachments"), fileName);
Upload.SaveAs(path);
}
BookingModel.AttachmentPath = fileName;
ManualBookingService bkService = new ManualBookingService();
msg = bkService.Save(BookingModel, "ripl", 123);
}
catch (Exception ex)
{
msg.MessageId = 1;
msg.Message = ex.Message;
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
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 ManualBookingModel GetByKeyId(int ManualBookingId)
{
ManualBookingModel mbm = new ManualBookingModel();
//mbm.BookingNo = "1234";
return(mbm);
}
private ManualBookingModel GenerateManualBookingModel(DataRow Row)
{
ManualBookingModel mbm = new ManualBookingModel();
mbm.BookingNo = Row["LR_No"].ToString();
mbm.BookingDate = Convert.ToDateTime(Row["LR_Date"].ToString());
mbm.FromLocation = Row["From_Service_Network"].ToString();
mbm.ToLocation = Row["To_Service_Network"].ToString();
mbm.VechicleNo = Row["Vehicle_No"].ToString();
mbm.CustomerName = Row["Customer_Name"].ToString();
mbm.BookingWeight = Decimal.Parse(Row["Weight"].ToString());
mbm.BookingNoOfPackages = int.Parse(Row["NoOfArticles"].ToString());
mbm.ManualBookingId = int.Parse(Row["Booking_Manual_ID"].ToString());
mbm.AttachmentPath = Row["Attachment_Path"].ToString();
return(mbm);
}
