protected void btnSubmit_Click(object sender, EventArgs e)
{
Lot _Lot = new Lot();
_Lot.Name = Name.Text;
_Lot.Description = Description.Text;
_Lot.IsDeleted = false;
lblMessage.Text = Lot_DA.InsertLot(_Lot);
if (lblMessage.Text == Constants.ALREADY_EXIST)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
}
else
lblMessage.ForeColor = System.Drawing.Color.Green;
}
private void SendNotification(Lot _Lot, DataTable dt)
{
string MessageBody = "Edited By : <b>" + Session["User"].ToString().ToUpper() + "</b><br><br>" + DateTime.UtcNow.AddHours(5) + "<br><h3>Before Edit</h3>";
string tableStart = "<table style=\" width:100%;border-collapse: collapse;\">";//border: 1px solid #ddd;
string tableEnd = "</table>";
string MessageHeader = "<tr>";
string MessageDataOld = "<tr>";
string MessageDataNew = "<tr>";
for (int i = 1; i < dt.Columns.Count - 1; i++)
{
MessageHeader += "<th align=\"left\" style=\"border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;height: 30px;\">" + dt.Columns[i].ColumnName + "</th>";
MessageDataOld += "<td style=\"border-top: 1px solid #ddd;border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0][i] + "</td>";
}
MessageDataOld += "</tr>";
MessageHeader += "</tr>";
MessageDataNew += "<td style=\"border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _Lot.Name + "</td>";
MessageDataNew += "<td style=\"border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _Lot.Description + "</td>";
MessageDataNew += "</tr>";
MessageBody += tableStart + MessageDataOld + MessageHeader + MessageDataNew + tableEnd + "<h3>After Edit</h3>";
sendMail.sendEmailMessage(ConfigurationManager.AppSettings["From"], ConfigurationManager.AppSettings["To"], ConfigurationManager.AppSettings["Password"], "Lot Edit", MessageBody);
}
public string Update(int Id, string Name, string Description)
{
Lot _Lot = new Lot();
_Lot.Id = Id;
_Lot.Name = Name;
_Lot.Description = Description;
DataTable dt = Lot_DA.Get_Lot_By_Id(_Lot.Id);
string message = Lot_DA.UpdateLot(_Lot);
if (message != "1" && Session["User"].ToString().ToUpper() != ("Mustafa Piracha").ToUpper())
{
SendNotification(_Lot, dt);
}
return message;
}
public Lot Get_Lot_By_Id(int Id)
{
Lot _Lot = new Lot();
DataTable dt = Lot_DA.Get_Lot_By_Id(Id);
foreach (DataRow row in dt.Rows)
{
//int Id = int.Parse(row["Id"].ToString());
string Name = row["Name"].ToString();
string Description = row["Description"].ToString();
bool IsDeleted = Convert.ToBoolean(row["IsDeleted"].ToString());
_Lot.Id = Id;
_Lot.Name = Name;
_Lot.Description = Description;
_Lot.IsDeleted = IsDeleted;
}
return _Lot;
}
public static string UpdateLot(Lot _Lot)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_UpdateLot";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@Id";
param.Value = _Lot.Id;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Name";
param.Value = _Lot.Name;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Description";
param.Value = _Lot.Description;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
string Return = command.Parameters["@Return"].Value.ToString();
return Return;
}
public static string InsertLot(Lot _Lot)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_insertLot";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@Name";
param.Value = _Lot.Name;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Description";
param.Value = _Lot.Description;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@IsDeleted";
param.Value = _Lot.IsDeleted;
param.DbType = DbType.Boolean;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
string Return = command.Parameters["@Return"].Value.ToString();
if (Return == Constants.SP_ALREADY_EXIST)
{
return Constants.ALREADY_EXIST;
}
else
{
return Constants.SUCESS_INSERT;
}
}
