Esempio n. 1
0
        public HttpResponseMessage UpdatePlantStorageDetails(TEPOPlantStorageDetail plntstoragedtl)
        {
            try
            {
                TEPOPlantStorageDetail plntObj = db.TEPOPlantStorageDetails.Where(a => a.PlantStorageDetailsID == plntstoragedtl.PlantStorageDetailsID && a.isdeleted == false).FirstOrDefault();
                if (plntObj != null)
                {
                    TEProject proj = db.TEProjects.Where(a => a.ProjectID == plntstoragedtl.ProjectID && a.IsDeleted == false).FirstOrDefault();
                    plntObj.LastModifiedOn = DateTime.Now;
                    plntObj.isdeleted      = false;
                    if (proj != null)
                    {
                        plntObj.ProjectName = proj.ProjectName;
                        plntObj.ProjectCode = proj.ProjectCode;
                    }
                    TEGSTNStateMaster state = db.TEGSTNStateMasters.Where(a => a.StateID == plntstoragedtl.StateID && a.IsDeleted == false).FirstOrDefault();
                    if (state != null)
                    {
                        plntObj.StateCode            = state.StateCode;
                        plntObj.StateCodeDescription = state.StateName;
                    }
                    plntObj.Address          = plntstoragedtl.Address;
                    plntObj.CompanyCode      = plntstoragedtl.CompanyCode;
                    plntObj.CountryCode      = plntstoragedtl.CountryCode;
                    plntObj.GSTIN            = plntstoragedtl.GSTIN;
                    plntObj.PlantStorageCode = plntstoragedtl.PlantStorageCode;
                    plntObj.Type             = plntstoragedtl.Type;
                    plntObj.StateID          = plntstoragedtl.StateID;
                    plntObj.ProjectID        = plntstoragedtl.ProjectID;
                    db.Entry(plntObj).CurrentValues.SetValues(plntObj);
                    db.SaveChanges();

                    sinfo.errorcode    = 0;
                    sinfo.errormessage = "Successfully Updated";
                    return(new HttpResponseMessage()
                    {
                        Content = new JsonContent(new { info = sinfo })
                    });
                }
                else
                {
                    sinfo.errorcode    = 0;
                    sinfo.errormessage = "Unable to Update";
                    return(new HttpResponseMessage()
                    {
                        Content = new JsonContent(new { info = sinfo })
                    });
                }
            }
            catch (Exception ex)
            {
                ExceptionObj.RecordUnHandledException(ex);
                sinfo.errorcode    = 1;
                sinfo.errormessage = "Fail To Update";
                return(new HttpResponseMessage()
                {
                    Content = new JsonContent(new { info = sinfo })
                });
            }
        }
Esempio n. 2
0
        public HttpResponseMessage DeletePlantStorageDetails(TEPOPlantStorageDetail plntstoragedtl)
        {
            try
            {
                TEPOPlantStorageDetail plntObj = db.TEPOPlantStorageDetails.Where(a => a.PlantStorageDetailsID == plntstoragedtl.PlantStorageDetailsID && a.isdeleted == false).FirstOrDefault();
                if (plntObj != null)
                {
                    plntObj.LastModifiedOn = DateTime.Now;
                    plntObj.isdeleted      = true;
                    db.Entry(plntObj).CurrentValues.SetValues(plntObj);
                    db.SaveChanges();

                    sinfo.errorcode    = 0;
                    sinfo.errormessage = "Successfully Deleted";
                    return(new HttpResponseMessage()
                    {
                        Content = new JsonContent(new { info = sinfo })
                    });
                }
                else
                {
                    sinfo.errorcode    = 0;
                    sinfo.errormessage = "Unable to Delete";
                    return(new HttpResponseMessage()
                    {
                        Content = new JsonContent(new { info = sinfo })
                    });
                }
            }
            catch (Exception ex)
            {
                ExceptionObj.RecordUnHandledException(ex);
                sinfo.errorcode    = 1;
                sinfo.errormessage = "Fail To Delete";
                return(new HttpResponseMessage()
                {
                    Content = new JsonContent(new { info = sinfo })
                });
            }
        }
Esempio n. 3
0
        public HttpResponseMessage SavePlantStorageDetails(TEPOPlantStorageDetail plntstoragedtl)
        {
            try
            {
                TEProject proj = db.TEProjects.Where(a => a.ProjectID == plntstoragedtl.ProjectID && a.IsDeleted == false).FirstOrDefault();
                plntstoragedtl.LastModifiedOn = DateTime.Now;
                plntstoragedtl.isdeleted      = false;
                if (proj != null)
                {
                    plntstoragedtl.ProjectName = proj.ProjectName;
                    plntstoragedtl.ProjectCode = proj.ProjectCode;
                }
                TEGSTNStateMaster state = db.TEGSTNStateMasters.Where(a => a.StateID == plntstoragedtl.StateID && a.IsDeleted == false).FirstOrDefault();
                if (state != null)
                {
                    plntstoragedtl.StateCode            = state.StateCode;
                    plntstoragedtl.StateCodeDescription = state.StateName;
                }
                db.TEPOPlantStorageDetails.Add(plntstoragedtl);
                db.SaveChanges();

                sinfo.errorcode    = 0;
                sinfo.errormessage = "Successfully Saved";
                return(new HttpResponseMessage()
                {
                    Content = new JsonContent(new { info = sinfo })
                });
            }
            catch (Exception ex)
            {
                ExceptionObj.RecordUnHandledException(ex);
                sinfo.errorcode    = 1;
                sinfo.errormessage = "Fail To Save";
                return(new HttpResponseMessage()
                {
                    Content = new JsonContent(new { info = sinfo })
                });
            }
        }