public string Get_Sensor_ById(int id)
{
tblSensorMaster sens = sensorrepo.Get_Sensor_by_Id(id);
string json = new JavaScriptSerializer().Serialize(sens);
return(json);
}
public string Check_SensorIP(string plantcode, string ip)
{
string json = string.Empty;
tblSensorMaster sens = sensorrepo.Get_Sensor_List().FirstOrDefault(x => x.PlantCode == plantcode && x.SensorIP == ip);
if (sens != null)
{
json = new JavaScriptSerializer().Serialize(sens);
}
return(json);
}
public string Check_Sensor(string plantcode, string machineid)
{
string json = string.Empty;
tblSensorMaster sens = sensorrepo.Get_Sensor_List().Where(x => x.PlantCode == plantcode && x.MachineId == machineid).FirstOrDefault();
if (sens != null)
{
json = new JavaScriptSerializer().Serialize(sens);
}
return(json);
}
//Add:New Sensor Master
public bool Add_Sensor(tblSensorMaster master)
{
bool status = false;
if (master != null)
{
db.tblSensorMasters.InsertOnSubmit(master);
db.SubmitChanges();
status = true;
}
return(status);
}
//Delete:Sensor Master Record by Id
public bool Delete_Sensor(int id)
{
bool status = false;
tblSensorMaster sensor = db.tblSensorMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
if (sensor != null)
{
sensor.IsDeleted = true;
db.SubmitChanges();
status = true;
}
return(status);
}
//Update:Sensor Record by Id
protected void Update_Sensor()
{
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
try
{
int id = Convert.ToInt32(Request.QueryString["Id"]);
var data = sensrepo.Get_Sensor_List().FirstOrDefault(x => x.PlantCode == ddlplantcode.SelectedValue && x.MachineId == ddlmachineid.SelectedValue && x.Id != id && x.IsDeleted == false);
var data2 = sensrepo.Get_Sensor_List().FirstOrDefault(x => x.PlantCode == ddlplantcode.SelectedValue && x.Id != id && x.IsDeleted == false);
if (data != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Machine Configuration Already Exist! Please try again');", true);
}
else if (data2 != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Sensor IP Already Exist! Plese try again');", true);
}
else
{
tblSensorMaster sensor = db.tblSensorMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
sensor.PlantCode = ddlplantcode.SelectedValue;
sensor.MachineId = ddlmachineid.SelectedValue;
sensor.SensorIdentification = txtidentification.Text.Trim().ToString();
if (regex.CheckIPAddress(txtip.Text.Trim()))
{
sensor.SensorIP = txtip.Text.Trim().ToString();
sensor.SensorPort = txtport.Text.Trim().ToString();
db.SubmitChanges();
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Update Successfully');", true);
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
meta.Content = "1;url = AddEdit.aspx?id=" + id;
this.Page.Controls.Add(meta);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Invalid IP Address');", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('" + ex.Message.ToString() + "');", true);
}
}
}
//Add:New Sensor
protected void Add_Sensor()
{
try
{
var data = sensrepo.Get_Sensor_List().FirstOrDefault(x => x.PlantCode == ddlplantcode.SelectedValue && x.MachineId == ddlmachineid.SelectedValue && x.IsDeleted == false);
var data2 = sensrepo.Get_Sensor_List().FirstOrDefault(x => x.PlantCode == ddlplantcode.SelectedValue && x.SensorIP == txtip.Text.Trim() && x.IsDeleted == false);
if (data != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Machine Configuration Exist! Please Try Again')", true);
}
else if (data2 != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Sensor IP Exist');", true);
}
else
{
tblSensorMaster sensor = new tblSensorMaster();
sensor.PlantCode = ddlplantcode.SelectedValue.ToString();
sensor.MachineId = ddlmachineid.SelectedValue.ToString();
sensor.SensorIdentification = txtidentification.Text.Trim();
if (regex.CheckIPAddress(txtip.Text.Trim()))
{
sensor.SensorIP = txtip.Text.Trim();
sensor.SensorPort = txtport.Text.Trim();
sensor.IsDeleted = false;
if (sensrepo.Add_Sensor(sensor))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Save Successfully');", true);
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
meta.Content = "0.30;url=AddEdit.aspx";
this.Page.Controls.Add(meta);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Invalid IP Address');", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true);
}
}
//Get:Sensor Master for Edit
protected void Get_SensorForEdit()
{
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
try
{
int id = Convert.ToInt32(Request.QueryString["Id"]);
tblSensorMaster sen = sensrepo.Get_Sensor_by_Id(id);
if (sen != null)
{
ddlplantcode.SelectedValue = sen.PlantCode;
Get_MachineId_By_PlantCode(ddlplantcode.SelectedValue);
ddlmachineid.SelectedValue = sen.MachineId;
txtidentification.Text = sen.SensorIdentification;
txtip.Text = sen.SensorIP;
txtport.Text = sen.SensorPort;
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('" + ex.Message.ToString() + "');", true);
}
}
}
//Save:Excel File Data To the Server
public string SaveDataToServer(DataSet ds)
{
string result = string.Empty;
int success = 0;
int fail = 0;
int update = 0;
string PlantCode = string.Empty;
string MachineId = string.Empty;
string SensorIdentification = string.Empty;
string SensorIP = string.Empty;
string SensorPort = string.Empty;
DataTable dt = ds.Tables[0];
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (DataRow dr in dt.Rows)
{
try
{
PlantCode = dr["Plant Code"].ToString().Trim();
MachineId = dr["Machine Id"].ToString().Trim();
SensorIdentification = dr["Sensor Identification"].ToString().Trim();
SensorIP = dr["Sensor IP"].ToString().Trim();
SensorPort = dr["Sensor Port"].ToString().Trim();
if (PlantCode.Length <= 10 && MachineId.Length <= 10 && SensorIdentification.Length <= 10 && SensorIP.Length <= 15 && SensorPort.Length <= 5)
{
if (regex.CheckIPAddress(SensorIP))
{
var PlantMaster = plantrepo.Get_PlantMaster_By_PlantCode(PlantCode);
var WeightMachine = wmrepo.GetMachineMasters_List().Where(x => x.PlantCodeId == PlantCode && x.IsDeleted == false).ToList();
if (PlantMaster != null && WeightMachine.Count > 0)
{
var sens = Get_Sensor_List().FirstOrDefault(x => x.PlantCode == PlantCode && x.MachineId == MachineId && x.IsDeleted == false);
var data = Get_Sensor_List().FirstOrDefault(x => x.PlantCode == PlantCode && x.SensorIP == SensorIP && x.Id != sens.Id && x.IsDeleted == false);
if (sens != null)
{
tblSensorMaster sensor = db.tblSensorMasters.FirstOrDefault(x => x.Id == sens.Id && x.IsDeleted == false);
if (sensor != null)
{
if (data != null)
{
fail++;
}
else
{
sensor.PlantCode = PlantCode;
sensor.MachineId = MachineId;
sensor.SensorIdentification = SensorIdentification;
sensor.SensorIP = SensorIP;
sensor.SensorPort = SensorPort;
db.SubmitChanges();
update++;
}
}
}
else
{
var data2 = Get_Sensor_List().FirstOrDefault(x => x.PlantCode == PlantCode && x.SensorIP == SensorIP && x.IsDeleted == false);
tblSensorMaster sensor = new tblSensorMaster();
if (data2 != null)
{
fail++;
}
else
{
sensor.PlantCode = PlantCode;
sensor.MachineId = MachineId;
sensor.SensorIdentification = SensorIdentification;
sensor.SensorIP = SensorIP;
sensor.SensorPort = SensorPort;
sensor.IsDeleted = false;
db.tblSensorMasters.InsertOnSubmit(sensor);
db.SubmitChanges();
success++;
}
}
}
else
{
fail++;
}
}
else
{
fail++;
}
}
else
{
fail++;
}
}
catch (Exception ex)
{
fail++;
}
}
result = "New Added:-" + success + " Updated:-" + update + " Failed:-" + fail + "";
}
return(result);
}
//Get:Sensor Master Record by Id
public tblSensorMaster Get_Sensor_by_Id(int id)
{
tblSensorMaster sensor = db.tblSensorMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
return(sensor);
}
//Get:Sensor By PlantCode and Sensor IP
public tblSensorMaster Get_SensorBy_PlantCode_N_IP(string plantcode, string IP)
{
tblSensorMaster sensor = db.tblSensorMasters.FirstOrDefault(x => x.PlantCode == plantcode && x.SensorIP == IP && x.IsDeleted == false);
return(sensor);
}
