public string GetAlphaByCode(string code)
{
AlphaDisplayMaster alphaDisplay = _alpharepo.GetAlphaDisplayByCode(code.ToLower());
string myjsonresult = (new JavaScriptSerializer()).Serialize(alphaDisplay);
return(myjsonresult);
}
//Add:New AlphaDisplayMaster Record
public bool Add_AlphaDisplay(AlphaDisplayMaster alpha)
{
bool status = false;
if (alpha != null)
{
db.AlphaDisplayMasters.InsertOnSubmit(alpha);
db.SubmitChanges();
status = true;
}
return(status);
}
//Delete:AlphaDisplayMaster by Id
public bool Delete_AlphaDisplayById(int id)
{
bool status = false;
AlphaDisplayMaster master = db.AlphaDisplayMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
if (master != null)
{
master.IsDeleted = true;
db.SubmitChanges();
status = true;
}
return(status);
}
//Add:New AlphaDisplayMaster Record
private void Add()
{
try
{
int count = db.AlphaDisplayMasters.Count(x => x.PlantCodeId == ddlplantcode.SelectedValue && x.MachineId == ddlmachineid.SelectedValue && x.IsDeleted == false);
if (count < 2)
{
var check = db.AlphaDisplayMasters.Where(x => x.PlantCodeId == ddlplantcode.SelectedValue && x.AlphaDisplayIP == txtip.Text && x.IsDeleted == false).FirstOrDefault();
if (check != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Alpha Display IP Exist! Please Try Again.');", true);
}
else
{
AlphaDisplayMaster _ad = new AlphaDisplayMaster();
_ad.PlantCodeId = ddlplantcode.SelectedValue;
_ad.MachineId = ddlmachineid.SelectedValue;
_ad.AlphaDisplayIdentification = txtidentification.Text.ToString();
_ad.AlphaDisplayIP = txtip.Text.ToString();
_ad.AlphaDisplayPort = txtport.Text.ToString();
_ad.IsDeleted = false;
if (_repo.Add_AlphaDisplay(_ad))
{
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 Alpha Display Allow In 1 Plant.');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true);
}
}
//Get:AlphaDisplayMaster Previous Record
protected void Previous_Record_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["Id"].ToString());
AlphaDisplayMaster next = null;
try
{
next = _repo.GetAlphaDisplayMasters_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 fail = 0;
int success = 0;
int update = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
string PlantCodeId = dr["Plant Code Id"].ToString();
string MachineId = dr["Machine Id"].ToString();
string AlphaDisplayIdentification = dr["Alpha Display Identification"].ToString();
string AlphaDisplayIp = dr["Alpha Display IP"].ToString();
string AlphaDisplayPort = dr["Alpha Display PORT"].ToString();
var plantmaster = db.PlantMasters.Where(x => x.PlantCode == PlantCodeId && x.IsDeleted == false).ToList();
var machinemaster = db.WeightMachineMasters.Where(x => x.MachineId == MachineId && x.IsDeleted == false).ToList();
int count = db.AlphaDisplayMasters.Count(x => x.PlantCodeId == PlantCodeId & x.MachineId == MachineId && x.IsDeleted == false);
if (plantmaster.Count > 0 && machinemaster.Count > 0)
{
if (AlphaDisplayIdentification.Length <= 10 && AlphaDisplayIp.Length <= 15 && AlphaDisplayPort.Length <= 5)
{
var data = db.AlphaDisplayMasters.FirstOrDefault(x => x.PlantCodeId == PlantCodeId && x.MachineId == MachineId && x.AlphaDisplayIP == AlphaDisplayIp && x.IsDeleted == false);
var IPExist = db.AlphaDisplayMasters.FirstOrDefault(x => x.PlantCodeId == PlantCodeId && x.AlphaDisplayIP == AlphaDisplayIp && x.Id != data.Id && x.IsDeleted == false);
if (data != null)
{
if (IPExist == null)
{
if (regex.CheckIPAddress(AlphaDisplayIp))
{
data.PlantCodeId = PlantCodeId;
data.MachineId = MachineId;
data.AlphaDisplayPort = AlphaDisplayPort;
data.AlphaDisplayIdentification = AlphaDisplayIdentification;
data.AlphaDisplayIP = AlphaDisplayIp;
db.SubmitChanges();
update++;
}
else
{
fail++;
}
}
else
{
fail++;
}
}
else
{
if (count < 2)
{
var a = db.AlphaDisplayMasters.FirstOrDefault(x => x.PlantCodeId == PlantCodeId && x.AlphaDisplayIP == AlphaDisplayIp && x.IsDeleted == false);
if (a != null)
{
if (regex.CheckIPAddress(AlphaDisplayIp))
{
AlphaDisplayMaster alpha = new AlphaDisplayMaster();
alpha.PlantCodeId = PlantCodeId;
alpha.MachineId = MachineId;
alpha.AlphaDisplayIdentification = AlphaDisplayIdentification;
alpha.AlphaDisplayIP = AlphaDisplayIp;
alpha.AlphaDisplayPort = AlphaDisplayPort;
db.AlphaDisplayMasters.InsertOnSubmit(alpha);
db.SubmitChanges();
success++;
}
}
}
else
{
fail++;
}
}
}
else
{
fail++;
}
}
else
{
fail++;
}
}
catch
{
fail++;
}
}
result = "New Added: " + success + " Updated: " + update + " Failed: " + fail + "";
}
return(result);
}
//Get:AlphaDisplayMaster by Id
public AlphaDisplayMaster Get_AlphaDisplayById(int id)
{
AlphaDisplayMaster master = db.AlphaDisplayMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
return(master);
}
