//:Get Plant Master For Update
private void Get_PlantInfo_ForEdit()
{
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
divoptions.Style.Add("display", "block");
txtPlantCOde.Enabled = false;
int id = Convert.ToInt32(Request.QueryString["Id"]);
PlantMaster _pm = repo.Get_PlantMaster_by_Id(id);
if (_pm != null)
{
txtPlantCOde.Text = _pm.PlantCode.ToString();
txtPlantName.Text = _pm.PlantName.ToString();
txtDesignation.Text = _pm.Designation.ToString();
txtContactPerson.Text = _pm.PlantContactPerson.ToString();
txtContactMobile.Text = _pm.ContactMobile.ToString();
txtContactEmail.Text = _pm.ContactEmail.ToString();
txtAddress1.Text = _pm.PlantAddress1.ToString();
txtAddress2.Text = _pm.PlantAddress2.ToString();
txtMachineCount.Text = _pm.NoOfMachine.ToString();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Plant code not found.please try again');", true);
}
}
}
public string Get_PlantMasterByCode(string code)
{
PlantMaster _pm = _plantrepo.Get_PlantMaster_By_PlantCode(code.ToLower());
string myjsonresult = new JavaScriptSerializer().Serialize(_pm);
return(myjsonresult);
}
public string Check_PlantMaster(string code)
{
code = code.ToLower();
string jsonstring = string.Empty;
PlantMaster mat = _plantrepo.Get_PlantList().Where(x => x.PlantCode.ToLower() == code && x.IsDeleted == false).FirstOrDefault();
if (mat != null)
{
jsonstring = new JavaScriptSerializer().Serialize(mat);
}
return(jsonstring);
}
//Add:New plant master
public bool Add_PlantMaster(PlantMaster plant)
{
bool status = false;
if (plant != null)
{
db.PlantMasters.InsertOnSubmit(plant);
db.SubmitChanges();
status = true;
}
return(status);
}
//Delete:Plant Master By Id
public bool Delete_PlantById(int id)
{
bool status = false;
PlantMaster plant = db.PlantMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
if (plant != null)
{
plant.IsDeleted = true;
db.SubmitChanges();
status = true;
}
return(status);
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
string _UserName = UserName.Value;
string _Password = Password.Value;
string _WBID = WBID.Value;
string _PlantID = PlantID.Value;
UserMaster um = umRepo.CheckUserCredentials(_UserName, _Password, _WBID, _PlantID);
SiteParameterSetting setting = db.SiteParameterSettings.FirstOrDefault();
PlantMaster _plantCode = db.PlantMasters.Where(x => x.PlantCode == _PlantID).FirstOrDefault();
if (um != null && um.Id != 0)
{
Session["UserName"] = _UserName;
Session["Password"] = _Password;
Session["WBID"] = _WBID;
Session["UserId"] = um.Id;
Session["PlantID"] = _PlantID;
Session["CompanyCode"] = _plantCode.CompanyCode;
Session["WBFORM"] = "0";
GLOBALVARIABLE();
FormsAuthentication.RedirectFromLoginPage(um.Id.ToString(), true);
UserClassification uc = umRepo.GetUserAuthorization(um.Id);
New_Weighing_Unit(_WBID, _PlantID);
Session["FIRSTWT_RCD"] = "0";
Session["SECONDWT_RCD"] = "0";
if (uc != null)
{
if (uc.GateEntry == true)
{
Response.Redirect("/GateEntryForm");
}
else if (uc.Weighment == false)
{
Session["WBFORM"] = "1";
Response.Redirect("/ManageMasters");
}
else
{
Response.Redirect("/Manual_Weighment");
}
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.error('No User account found. Please try again.');", true);
}
}
//:Get Previous Record From Plant Master
protected void Previous_Record_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["Id"].ToString());
PlantMaster next = null;
try
{
next = repo.Get_PlantList().Where(x => x.Id < id && x.IsDeleted == false).OrderByDescending(i => i.Id).FirstOrDefault();
}
catch
{
}
if (next != null)
{
Response.Redirect("PlantInfo.aspx?id=" + next.Id.ToString());
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('No more records founds.')", true);
}
}
//Update:Plant Master Record
private void Update_PlantInfo()
{
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
int Id = Convert.ToInt32(Request.QueryString["Id"].ToString());
//PlantMaster _master = repo.Get_PlantMaster_by_Id(Id);
PlantMaster _master = db.PlantMasters.FirstOrDefault(x => x.Id == Id && x.IsDeleted == false);
if (_master != null)
{
PlantMaster _plant = repo.Get_PlantList().Where(x => x.PlantCode == txtPlantCOde.Text && x.Id != Id && x.IsDeleted == false).FirstOrDefault();
if (_plant != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Plant Code Exist! Please Try Again.');", true);
}
else
{
_master.ContactEmail = txtContactEmail.Text;
_master.ContactMobile = txtContactMobile.Text;
_master.Designation = txtDesignation.Text;
_master.NoOfMachine = Convert.ToInt32(txtMachineCount.Text);
_master.PlantAddress1 = txtAddress1.Text;
_master.PlantAddress2 = txtAddress2.Text;
_master.PlantCode = txtPlantCOde.Text;
_master.PlantContactPerson = txtContactPerson.Text;
_master.PlantName = txtPlantName.Text.Trim().ToString();
db.SubmitChanges();
ClientScript.RegisterStartupScript(this.GetType(), "toastr", "toastr.success('Plant info updated successfully.');", true);
HtmlMeta meta = new HtmlMeta
{
HttpEquiv = "Refresh",
Content = "1;url=PlantInfo.aspx?id=" + Id
};
this.Page.Controls.Add(meta);
}
}
}
}
//:Add New Plant Master Record
private void Add_PlantInfo()
{
PlantMaster _master = repo.Get_PlantMaster_By_PlantCode(txtPlantCOde.Text.Trim());
if (_master != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "toastr", "toastr.error('Same Plant code is already exists.');", true);
}
else
{
_master = new PlantMaster();
_master.ContactEmail = txtContactEmail.Text;
_master.ContactMobile = txtContactMobile.Text;
_master.Designation = txtDesignation.Text;
try
{
_master.NoOfMachine = Convert.ToInt32(txtMachineCount.Text);
}
catch { _master.NoOfMachine = 0; }
_master.PlantAddress1 = txtAddress1.Text;
_master.PlantAddress2 = txtAddress2.Text;
_master.PlantCode = txtPlantCOde.Text;
_master.PlantContactPerson = txtContactPerson.Text;
_master.PlantName = txtPlantName.Text;
_master.IsDeleted = false;
if (repo.Add_PlantMaster(_master))
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.success('Plant info saved successfully.');", true);
HtmlMeta meta = new HtmlMeta
{
HttpEquiv = "Refresh",
Content = "1;url=PlantInfo.aspx"
};
this.Page.Controls.Add(meta);
}
}
}
protected void lnkprintPDF_Click(object sender, EventArgs e)
{
PlantMaster _plant = _plantRepo.getplantByWeighingMachine(Session["PlantID"].ToString(), "com1");
//BaseFont bfR = iTextSharp.text.pdf.BaseFont.CreateFont(BaseFont.TIMES_ROMAN, iTextSharp.text.pdf.BaseFont.CP1257, iTextSharp.text.pdf.BaseFont.EMBEDDED);
//PdfWriter writer = PdfWriter.GetInstance(document, fs);
StyleSheet style1 = new StyleSheet();
style1.LoadTagStyle(HtmlTags.TABLE, HtmlTags.FONTSIZE, "8px");
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=DateWiseReports.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
hw.AddStyleAttribute("font-size", "8pt");
// rptList.DataBind();
Panel1.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f);
// pdfDoc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate());
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
string CompanyLogo = HttpContext.Current.Server.MapPath(".") + @"\images\companylogo\logo.jpg";
string header1 = HttpContext.Current.Server.MapPath(".") + @"\images\header1.png";
string header2 = HttpContext.Current.Server.MapPath(".") + @"\images\header2.png";
//imgLogo.ImageUrl = "/images/companylogo/" + company.CompanyLogo;
//added on 24-10-2019
BaseFont bfTimes = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, false);
var boldTableFont = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.BOLD);
var NORMALFont = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL);
PdfPTable table1 = new PdfPTable(4);
table1.WidthPercentage = 100;
table1.SetWidths(new float[] { 0.10f, 0.13f, 0.15f, 0.20f });
//First Row
PdfPCell cellheaderleft = new PdfPCell();
cellheaderleft.Border = 0;
iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(header1);
image.ScaleAbsolute(230f, 200f);
image.Alignment = Element.HEADER;
cellheaderleft.AddElement(image);
table1.AddCell(cellheaderleft);
cellheaderleft = new PdfPCell();
cellheaderleft.Border = 0;
image.ScaleAbsolute(230f, 200f);
image.Alignment = Element.HEADER;
cellheaderleft.AddElement(image);
table1.AddCell(cellheaderleft);
cellheaderleft = new PdfPCell();
cellheaderleft.Border = 0;
image.ScaleAbsolute(230f, 200f);
image.Alignment = Element.HEADER;
cellheaderleft.AddElement(image);
table1.AddCell(cellheaderleft);
PdfPCell cellheaderright = new PdfPCell();
cellheaderright.Border = 0;
cellheaderright.Rowspan = 2;
iTextSharp.text.Image image2 = iTextSharp.text.Image.GetInstance(header2);
image2.ScaleAbsolute(190f, 500f);
image2.Alignment = Element.HEADER;
cellheaderright.AddElement(image2);
table1.AddCell(cellheaderright);
//2nd Row
cellheaderleft = new PdfPCell();
cellheaderleft.Border = 0;
iTextSharp.text.Image logoImage = iTextSharp.text.Image.GetInstance(CompanyLogo);
image.ScaleAbsolute(250f, 200f);
image.Alignment = Element.HEADER;
cellheaderleft.AddElement(logoImage);
table1.AddCell(cellheaderleft);
cellheaderleft = new PdfPCell();
cellheaderleft.Border = 0;
table1.AddCell(cellheaderleft);
string PlantCodeAddress = _plant.PlantName + "\n" + _plant.PlantAddress1 + "\n" + _plant.PlantAddress2;
var p = new Paragraph(PlantCodeAddress, boldTableFont);
cellheaderleft = new PdfPCell();
cellheaderleft.Border = 0;
cellheaderleft.HorizontalAlignment = Element.ALIGN_CENTER;
cellheaderleft.AddElement(p);
table1.AddCell(cellheaderleft);
PdfPCell Reportname = new PdfPCell(new Phrase("Date wise Report", boldTableFont));
Reportname.HorizontalAlignment = Element.ALIGN_LEFT;
Reportname.Padding = 5;
Reportname.Colspan = 2;
table1.AddCell(Reportname);
PdfPCell tripdatetime = new PdfPCell(new Phrase("Print Date/Time :", boldTableFont));
tripdatetime.HorizontalAlignment = Element.ALIGN_RIGHT;
table1.AddCell(tripdatetime);
PdfPCell tripdatetimeValue = new PdfPCell(new Phrase(DateTime.Now.ToString(), NORMALFont));
tripdatetimeValue.HorizontalAlignment = Element.ALIGN_LEFT;
table1.AddCell(tripdatetimeValue);
pdfDoc.Add(table1);
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
//Save Excel File Data To SQL Server
public string SaveDataToServer(DataSet ds)
{
string result = string.Empty;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
string connection = ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString;
DataTable dt = ds.Tables[0];
int _failed = 0;
int _success = 0;
int _update = 0;
foreach (DataRow dr in dt.Rows)
{
int userid = 0;
string _UserName = dr["User Name"].ToString();
string _Password = dr["Password"].ToString();
string _UserType = dr["User Type"].ToString();
string _PlantCode = dr["Plant Code"].ToString();
string _machines = dr["Weigh Machines"].ToString();
int _UserTypeId = 0;
try
{
_UserTypeId = db.UserClassifications.FirstOrDefault(x => x.UserType == _UserType && x.IsDeleted == false).Id;
}
catch { }
PlantMaster _pm = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _PlantCode && x.IsDeleted == false);
var data = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName && x.IsDeleted == false);
if (data != null)
{
int id = 0;
try
{
id = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName && x.IsDeleted == false).Id;
}
catch
{
}
userid = id;
UserMaster _um = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName & x.IsDeleted == false && x.Id != id);
if (_um != null)
{
_failed++;
}
else
{
if (!string.IsNullOrEmpty(_Password) && !string.IsNullOrEmpty(_UserName) && _UserTypeId > 0 && _pm != null)
{
data.UserName = _UserName;
data.Password = _Password;
data.UserType = _UserTypeId;
data.Plantcode = _PlantCode;
db.SubmitChanges();
_update++;
}
else
{
_failed++;
}
}
}
else
{
int id = db.UserClassifications.FirstOrDefault(x => x.UserType == _UserType && x.IsDeleted == false).Id;
var _plant = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _PlantCode && x.IsDeleted == false);
if (id > 0 && _plant != null && !string.IsNullOrEmpty(_UserName) && !string.IsNullOrEmpty(_Password))
{
var _user = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName && x.IsDeleted == false);
if (_user != null)
{
_failed++;
}
else
{
UserMaster _um = new UserMaster();
_um.UserName = _UserName;
_um.Password = _Password;
_um.UserType = id;
_um.Plantcode = _PlantCode;
db.UserMasters.InsertOnSubmit(_um);
db.SubmitChanges();
userid = _um.Id;
_success++;
}
}
}
string[] machines = _machines.Split(',');
foreach (string _mc in machines)
{
int machineId = 0;
try
{
machineId = db.WeightMachineMasters.Where(x => x.MachineId == _mc).FirstOrDefault().Id;
}
catch { }
if (machineId != 0 && userid != 0)
{
UserWeightMachineMaster uwmm = db.UserWeightMachineMasters.Where(x => x.UserId == userid && x.WeightMachineId == machineId).FirstOrDefault();
if (uwmm == null)
{
uwmm = new UserWeightMachineMaster();
uwmm.WeightMachineId = machineId;
uwmm.UserId = userid;
db.UserWeightMachineMasters.InsertOnSubmit(uwmm);
db.SubmitChanges();
}
}
}
}
result = "Result: Not saved: " + _failed + ", Saved: " + _success + ", Updated: " + _update;
}
return(result);
}
//Save:Excel file data to the server
public string SaveDataToServer(DataSet ds)
{
string result = string.Empty;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
string connection = ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString;
DataTable dt = ds.Tables[0];
int _failed = 0;
int _success = 0;
int _update = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
string _PlantCode = dr["Plant Code"].ToString();
string _MachineId = dr["Machine Id"].ToString();
string _IPPort = dr["IP Port"].ToString();
string _PortNo = dr["Port No"].ToString();
string _ModeOfComs = dr["Mode Of Coms"].ToString();
string _StabilityNos = dr["Stability Nos"].ToString();
string _StabilityRange = dr["Stability Range"].ToString();
int _ZeroInterlock = Convert.ToInt32(dr["Zero Interlock"]);
string _ZeroInterlockRange = dr["Zero Interlock Range"].ToString();
string _TransactionNoPrefix = dr["Transaction No Prefix"].ToString();
int _TareCheck = Convert.ToInt32(dr["Tare Check"]);
int _StoredTare = Convert.ToInt32(dr["Stored Tare"]);
var data = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
if (data != null)
{
if (string.IsNullOrEmpty(_IPPort) && string.IsNullOrEmpty(_PortNo) && string.IsNullOrEmpty(_ModeOfComs))
{
_failed++;
}
else
{
data.PlantCode = _PlantCode;
data.MachineId = _MachineId;
data.IPPort = _IPPort;
data.PortNo = _PortNo;
data.StabilityNos = _StabilityNos;
data.StabilityRange = _StabilityRange;
data.TransactionNoPrefix = _TransactionNoPrefix;
data.ZeroInterlock = _ZeroInterlock;
data.ZeroInterlockRange = _ZeroInterlockRange;
data.ModeOfComs = _ModeOfComs;
data.TareCheck = _TareCheck;
data.StoredTare = _StoredTare;
db.SubmitChanges();
_update++;
}
}
else
{
if (!string.IsNullOrEmpty(_PlantCode) && !string.IsNullOrEmpty(_MachineId) && !string.IsNullOrEmpty(_ModeOfComs) && !string.IsNullOrEmpty(_IPPort) && !string.IsNullOrEmpty(_PortNo))
{
PlantMaster _plantmaster = db.PlantMasters.Where(x => x.PlantCode == _PlantCode && x.IsDeleted == false).FirstOrDefault();
WeightMachineMaster _machinemaster = db.WeightMachineMasters.Where(x => x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
if (_plantmaster != null && _machinemaster != null)
{
tblMachineWorkingParameter _machineparameter = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
if (_machineparameter != null)
{
_failed++;
}
else
{
tblMachineWorkingParameter t = new tblMachineWorkingParameter();
t.PlantCode = _PlantCode;
t.MachineId = _MachineId;
t.IPPort = _IPPort;
t.PortNo = _PortNo;
t.StabilityNos = _StabilityNos;
t.StabilityRange = _StabilityRange;
t.TransactionNoPrefix = _TransactionNoPrefix;
t.ZeroInterlock = _ZeroInterlock;
t.ZeroInterlockRange = _ZeroInterlockRange;
t.TareCheck = _TareCheck;
t.StoredTare = _StoredTare;
t.ModeOfComs = _ModeOfComs;
db.tblMachineWorkingParameters.InsertOnSubmit(t);
db.SubmitChanges();
_success++;
}
}
else
{
_failed++;
}
}
else
{
_failed++;
}
}
}
catch
{
_failed++;
}
}
result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + "";
}
return(result);
}
//Save Excel File data to the server
public string SaveDataToServer(DataSet ds)
{
string result = string.Empty;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
string connection = ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString;
DataTable dt = ds.Tables[0];
int _failed = 0;
int _success = 0;
int _update = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
string _companycode = dr["Company Code"].ToString();
string _plantcode = dr["Plant Code"].ToString();
string _plantname = dr["Plant Name"].ToString();
string _plantcontactperson = dr["Plant Contact Person"].ToString();
string _designation = dr["Designation"].ToString();
string _contactmobile = dr["Contact Mobile"].ToString();
string _contactemail = dr["Contact Email"].ToString();
string _plantaddress1 = dr["Plant Address1"].ToString();
string _plantaddress2 = dr["Plant Address2"].ToString();
int? _noofmachine = Convert.ToInt32(dr["No Of Machine"]);
if (_plantcode.Length <= 10 && _plantname.Length <= 25 && _plantcontactperson.Length <= 25 && _designation.Length <= 25 && _contactmobile.Length <= 12 && _plantaddress1.Length <= 25 && _plantaddress2.Length <= 25 && _noofmachine.ToString().Length <= 3)
{
var _plantmaster = db.PlantMasters.Where(x => x.PlantCode == _plantcode && x.IsDeleted == false).FirstOrDefault();
if (_plantmaster != null)
{
if (string.IsNullOrEmpty(_plantname))
{
_failed++;
}
else
{
int id = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _plantcode && x.IsDeleted == false).Id;
var _pm = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _plantcode && x.IsDeleted == false && x.Id != id);
if (_pm != null)
{
_failed++;
}
else
{
if (regex.CheckNumber(_contactmobile) && regex.ValidateEmail(_contactemail))
{
_plantmaster.PlantCode = _plantcode.ToString();
_plantmaster.PlantName = _plantname.ToString();
_plantmaster.Designation = _designation.ToString();
_plantmaster.PlantContactPerson = _plantcontactperson.ToString();
_plantmaster.PlantAddress1 = _plantaddress1.ToString();
_plantmaster.PlantAddress2 = _plantaddress2.ToString();
_plantmaster.ContactEmail = _contactemail.ToString();
_plantmaster.ContactMobile = _contactmobile.ToString();
_plantmaster.NoOfMachine = _noofmachine;
db.SubmitChanges();
_update++;
}
else
{
_failed++;
}
}
}
}
else
{
if (!string.IsNullOrEmpty(_plantcode) && !string.IsNullOrEmpty(_plantname))
{
PlantMaster _master = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _plantcode && x.IsDeleted == false);
if (_master != null)
{
_failed++;
}
else
{
try
{
if (regex.CheckNumber(_contactmobile) && regex.ValidateEmail(_contactemail))
{
PlantMaster plant = new PlantMaster();
plant.PlantCode = _plantcode.ToString();
plant.PlantName = _plantname.ToString();
plant.Designation = _designation.ToString();
plant.PlantContactPerson = _plantcontactperson.ToString();
plant.PlantAddress1 = _plantaddress1.ToString();
plant.PlantAddress2 = _plantaddress2.ToString();
plant.ContactEmail = _contactemail.ToString();
plant.ContactMobile = _contactmobile.ToString();
plant.NoOfMachine = _noofmachine;
plant.IsDeleted = false;
db.PlantMasters.InsertOnSubmit(plant);
db.SubmitChanges();
_success++;
}
else
{
_failed++;
}
}
catch
{
_failed++;
}
}
}
else
{
_failed++;
}
}
}
}
catch
{
_failed++;
}
}
result = "New Added:- " + _success + " Updated:- " + _update + " Failed:- " + _failed + "";
}
return(result);
}
public PlantMaster getplantByWeighingMachine(string plantCode, string companyCode)
{
PlantMaster master = db.PlantMasters.Where(x => x.PlantCode == plantCode && x.CompanyCode == companyCode).FirstOrDefault();
return(master);
}
//Get:Plant Master By Plant Id
public PlantMaster Get_PlantMaster_by_Id(int id)
{
PlantMaster plant = db.PlantMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
return(plant);
}
//:Get Plant master record by plantcode
public PlantMaster Get_PlantMaster_By_PlantCode(string code)
{
PlantMaster plantMaster = db.PlantMasters.FirstOrDefault(x => x.PlantCode == code && x.IsDeleted == false);
return(plantMaster);
}
