public static string UpdateStatus(UpdateStatusBLL obj, string PhotoUrl)
{
long JobCardId = Convert.ToInt64(obj.JobCardId);
using (var dbContext = new BSSDBEntities())
{
var UpdateData = dbContext.TblJobCardDtls.Where(x => x.JobCardId == JobCardId).FirstOrDefault();
var UpdateHdrData = dbContext.TblJobCardHdrs.Where(x => x.JobCardId == JobCardId).FirstOrDefault();
if (UpdateData != null)
{
TblJobCardDtl bp = new TblJobCardDtl
{
JobCardId = obj.JobCardId,
No_Of_Panel = obj.NumberOfPanel,
PanelReplaced = obj.PanelReplaced,
StatusID = obj.StatusID,
ContractorId = obj.Contractor_Id,
NoOfGlass = obj.Glass,
CreatedBy = UpdateData.CreatedBy,
CreationDate = UpdateData.CreationDate,
ModifiedBy = obj.ModifiedBy,
ModifiedDate = DateTime.Now
};
dbContext.Entry(bp).State = EntityState.Added;
dbContext.SaveChanges();
UpdateHdrData.InsuranceCompanyId = obj.InsCompId;
UpdateHdrData.PaymentMode = obj.PaymentMode;
dbContext.Entry(UpdateHdrData).State = EntityState.Modified;
dbContext.SaveChanges();
//Updating photo details
UpdateStatusDAL.UpdatePhotoDtl(obj.JobCardId, PhotoUrl);
return("success");
}
else
{
return("Error");
}
}
}
public async Task <HttpResponseMessage> PostData()
{
string location = "";
string fileName = "";
if (!Request.Content.IsMimeMultipartContent())
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
var root = System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["PhotoUrl"]);
//LogService("Local Path:-"+ root.ToString());
var PhotoUrlServer = System.Configuration.ConfigurationManager.AppSettings["PhotoUrlServer"];
//LogService("PhotoUrlServer:-" + PhotoUrlServer.ToString());
Directory.CreateDirectory(root);
var provider = new MultipartFormDataStreamProvider(root);
var result = await Request.Content.ReadAsMultipartAsync(provider);
try
{
for (int i = 0; i < result.FileData.Count; i++)
{
fileName = result.FileData[i].Headers.ContentDisposition.FileName;
string fileserial = result.FileData[i].Headers.ContentDisposition.Name.Trim('"');
//LogService("fileName:-" + fileName);
if (fileName.StartsWith("\"") && fileName.EndsWith("\""))
{
fileName = fileName.Trim('"');
}
if (fileName.Contains(@"/") || fileName.Contains(@"\"))
{
fileName = Path.GetFileName(fileName);
Match regex = Regex.Match(root, @"(.+) \((\d+)\)\.\w+");
if (regex.Success)
{
fileName = regex.Groups[1].Value;
}
}
try
{
string fileType = Path.GetExtension(fileName);
string filename = DateTime.Now.Ticks.ToString();
//LogService("fileName" + fileName);
string ExlName = filename + fileType;
string str;
str = filename.Substring(filename.Length - 1, 1);
string ImageWithPath = string.Format("{0}{1}", filename + str, fileType);
PhotoUrlServer = PhotoUrlServer + ImageWithPath;
//LogService("PhotoUrlServer :-" + PhotoUrlServer);
location = Path.Combine(root, ImageWithPath);
//LogService("location :-" + location);
File.Move(result.FileData[i].LocalFileName, Path.Combine(root, ImageWithPath));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.OK, "2"));
}
}
var model = result.FormData["data"];
UpdateStatusBLL obj = new UpdateStatusBLL();
obj = JsonConvert.DeserializeObject <UpdateStatusBLL>(model);
//function calling for insertion of excel Data into DataBase table
if (result.FileData.Count == 0)
{
//LogService("No File Attached :-");
UpdateStatusDAL.UpdateStatus(obj, obj.PhotoUrl);
}
else
{
UpdateStatusDAL.UpdateStatus(obj, PhotoUrlServer);
//LogService("File Attached :-");
}
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.Accepted, e.Message));
}
return(Request.CreateResponse(HttpStatusCode.Accepted, "0"));
}
public string UpdateBodyShop(UpdateStatusBLL obj)
{
return(UpdateStatusDAL.UpdateStatus(obj, ""));
}
