public string Get_BarrierByCode(string code)
{
BarrierMaster _bb = _barrierrepo.GetBarrierByCode(code.ToLower());
string myjsonresult = (new JavaScriptSerializer()).Serialize(_bb);
return(myjsonresult);
}
//Add:New Barrier Master Record
public bool Add_BarrierMaster(BarrierMaster bar)
{
bool status = false;
if (bar != null)
{
db.BarrierMasters.InsertOnSubmit(bar);
db.SubmitChanges();
status = true;
}
return(status);
}
//Delete:Barrier Master By Id
public bool Delete_BarrierMaster(int id)
{
bool status = false;
BarrierMaster master = db.BarrierMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
if (master != null)
{
master.IsDeleted = true;
db.SubmitChanges();
status = true;
}
return(status);
}
//Add:New BarrierMaster Record
protected void Add_Barrier()
{
try
{
int count = _repo.GetBarrierMasters_List().Count(x => x.PlantCodeId == ddlplantid.SelectedValue && x.MachineId == ddlmachinid.SelectedValue && x.IsDeleted == false);
if (count < 2)
{
var check = _repo.GetBarrierMasters_List().Where(x => x.PlantCodeId == ddlplantid.SelectedValue && x.BarrierIP == txtip.Text && x.IsDeleted == false).FirstOrDefault();
if (check != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Barrier IP Exist! Please Try Again.');", true);
}
else
{
BarrierMaster _bm = new BarrierMaster();
_bm.PlantCodeId = ddlplantid.SelectedValue.ToString();
_bm.MachineId = ddlmachinid.SelectedValue.ToString();
_bm.BarrierIdentification = txtidentification.Text.ToString();
_bm.BarrierIP = txtip.Text.ToString();
_bm.BarrierPort = txtport.Text.ToString();
_bm.BarrierScheme = ddlscheme.SelectedValue.ToString();
_bm.IsDeleted = false;
if (_repo.Add_BarrierMaster(_bm))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Save Successfully')", true);
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
meta.Content = "1;url=AddEdit.aspx";
this.Page.Controls.Add(meta);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Maximum 2 Barrier Allow In 1 Plant.');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true);
}
}
//Get:Barrier master previous record
protected void Previous_Record_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["Id"].ToString());
BarrierMaster next = null;
try
{
next = _repo.GetBarrierMasters_List().Where(x => x.Id < id && x.IsDeleted == false).OrderByDescending(i => i.Id).FirstOrDefault();
}
catch
{
}
if (next != null)
{
Response.Redirect("AddEdit.aspx?id=" + next.Id.ToString());
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('No more records founds.')", true);
}
}
//Save:Excel 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 _plantcodeid = dr["Plant Code"].ToString();
string _machinid = dr["Machine Id"].ToString();
string _barrieridentification = dr["Barrier Identification"].ToString();
string _barrierip = dr["Barrier IP"].ToString();
string _barrierport = dr["Barrier PORT"].ToString();
string _barrierscheme = dr["Barrier Scheme"].ToString();
var _bm = db.BarrierMasters.Where(x => x.BarrierIP == _barrierip && x.IsDeleted == false).FirstOrDefault();
if (_bm != null)
{
var _plantcode = db.PlantMasters.Where(x => x.PlantCode == _plantcodeid && x.IsDeleted == false).FirstOrDefault();
var _mid = db.WeightMachineMasters.Where(x => x.MachineId == _machinid && x.IsDeleted == false).FirstOrDefault();
if (_plantcode != null && _mid != null)
{
_bm.PlantCodeId = _plantcodeid;
_bm.MachineId = _machinid;
_bm.BarrierIdentification = _barrieridentification;
_bm.BarrierPort = _barrierport;
if (_barrierscheme == "N/C" || _barrierscheme == "N/O")
{
_bm.BarrierScheme = _barrierscheme;
}
else
{
_bm.BarrierScheme = "";
}
_update++;
db.SubmitChanges();
}
else
{
_failed++;
}
}
else
{
if (!string.IsNullOrEmpty(_barrierip))
{
BarrierMaster _brm = db.BarrierMasters.Where(x => x.BarrierIP == _barrierip && x.IsDeleted == false).FirstOrDefault();
if (_brm != null)
{
_failed++;
}
else
{
if (_barrierscheme == "N/C" || _barrierscheme == "N/O")
{
}
else
{
_barrierscheme = "";
}
db.BarrierMasters.InsertOnSubmit(new BarrierMaster
{
PlantCodeId = _plantcodeid,
MachineId = _machinid,
BarrierIdentification = _barrieridentification,
BarrierIP = _barrierip,
BarrierPort = _barrierport,
BarrierScheme = _barrierscheme,
IsDeleted = false
});
_success++;
db.SubmitChanges();
}
}
else
{
_failed++;
}
}
}
catch
{
_failed++;
}
}
result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + "";
}
return(result);
}
//Get:Barrier Master by Id
public BarrierMaster Get_BarrierMasterBy_Id(int id)
{
BarrierMaster barrier = db.BarrierMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
return(barrier);
}
