public static WaterTreatmentEquipment GetByWTEID(int wte_id)
{
WaterTreatmentEquipment wte = new WaterTreatmentEquipment();
MyDBConnection myConn = new MyDBConnection();
SqlConnection conn = new SqlConnection();
SqlDataReader dr;
SqlCommand cmd = null;
string sql = "Select * from AquaOne.dbo.WaterTreatmentEquipment where wte_id = @wte_id";
try
{
// Open the connection
conn = myConn.OpenDB();
cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@wte_id", SqlDbType.Int).Value = wte_id;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read())
{
wte = FillDataRecord(dr);
}
dr.Close();
cmd.Dispose();
}
finally
{
//close the connection
myConn.CloseDB(conn);
}
return(wte);
}
public static int Save(WaterTreatmentEquipment wTEquipment)
{
int result;
MyDBConnection myConn = new MyDBConnection();
SqlConnection conn = new SqlConnection();
try
{
conn = myConn.OpenDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.InsertUpdateWTE";
if (wTEquipment.WTE_ID == -1)
{
cmd.Parameters.Add("@WTEID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@WTEID", SqlDbType.Int).Value = wTEquipment.WTE_ID;
}
cmd.Parameters.Add("@AccountID", SqlDbType.Int).Value = wTEquipment.AccountID;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = wTEquipment.Description;
cmd.Parameters.Add("@ProductCode", SqlDbType.VarChar).Value = wTEquipment.ProductCode;
cmd.Parameters.Add("@Manufacturer", SqlDbType.VarChar).Value = wTEquipment.Manufacturer;
cmd.Parameters.Add("@DateObtained", SqlDbType.DateTime).Value = wTEquipment.DateObtained;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = wTEquipment.CreatedDate;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = wTEquipment.ModifiedDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = wTEquipment.CreatedBy;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = wTEquipment.ModifiedBy;
DbParameter returnValue = cmd.CreateParameter();
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnValue);
cmd.ExecuteNonQuery();
result = Convert.ToInt32(returnValue.Value);
cmd.Dispose();
}
finally
{
myConn.CloseDB(conn);
}
return(result);
}
protected void gviewWTE_RowEditing(object sender, GridViewEditEventArgs e)
{
//show the modal popup
//load the formview
//get the id
int wteID = Convert.ToInt32((gviewWTE.Rows[e.NewEditIndex].FindControl("hdnWTEID") as HiddenField).Value.ToString());
WaterTreatmentEquipment wte = WTEManager.GetByWTEID(wteID);
WaterTreatmentEquipmentList wteList = new WaterTreatmentEquipmentList();
wteList.Add(wte);
fviewUpdateWTE.DataSource = wteList;
fviewUpdateWTE.DataBind();
this.modPopUpShowUpdateWTE.Show();
}
protected void lnkUpdateWTE_OnCommand(object sender, CommandEventArgs e)
{
//get details from formview hdnWteID
WaterTreatmentEquipment w = new WaterTreatmentEquipment();
w.WTE_ID = Convert.ToInt32((fviewUpdateWTE.FindControl("hdnWteID") as HiddenField).Value.ToString());
w.Description = (fviewUpdateWTE.FindControl("txtDescription") as TextBox).Text;
w.Manufacturer = (fviewUpdateWTE.FindControl("txtManufacturer") as TextBox).Text;
w.ProductCode = (fviewUpdateWTE.FindControl("txtProductCode") as TextBox).Text;
w.DateObtained = Convert.ToDateTime((fviewUpdateWTE.FindControl("txtDateObtained") as TextBox).Text);
w.ModifiedBy = User.Identity.Name.ToString();
//update the record
WTEManager.Save(w);
//re-display the gridview
DisplayWTE();
}
protected void lnkAddWTE_OnCommand(object sender, CommandEventArgs e)
{
//add record to db
//get date from form
WaterTreatmentEquipment w = new WaterTreatmentEquipment();
w.AccountID = _accountID;
w.ProductCode = (fviewWTE.FindControl("txtProductCode") as TextBox).Text;
w.Description = (fviewWTE.FindControl("txtDescription") as TextBox).Text;
w.Manufacturer = (fviewWTE.FindControl("txtManufacturer") as TextBox).Text;
w.DateObtained = Convert.ToDateTime((fviewWTE.FindControl("txtDateObtained") as TextBox).Text);
w.CreatedBy = User.Identity.Name.ToString();
w.WTE_ID = WTEManager.Save(w);
ClearWTEFields();
//populate the gridview
DisplayWTE();
}
private static WaterTreatmentEquipment FillDataRecord(IDataRecord dr)
{
WaterTreatmentEquipment wTEquipment = new WaterTreatmentEquipment();
wTEquipment.WTE_ID = dr.GetInt32(dr.GetOrdinal("WTE_ID"));
wTEquipment.AccountID = dr.GetInt32(dr.GetOrdinal("AccountID"));
wTEquipment.Description = dr.GetString(dr.GetOrdinal("Description"));
wTEquipment.ProductCode = dr.GetString(dr.GetOrdinal("ProductCode"));
if (!dr.IsDBNull(dr.GetOrdinal("ProductCode")))
{
wTEquipment.ProductCode = dr.GetString(dr.GetOrdinal("ProductCode"));
}
wTEquipment.Manufacturer = dr.GetString(dr.GetOrdinal("Manufacturer"));
wTEquipment.DateObtained = dr.GetDateTime(dr.GetOrdinal("DateObtained"));
wTEquipment.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CreatedDate"));
wTEquipment.ModifiedDate = dr.GetDateTime(dr.GetOrdinal("ModifiedDate"));
wTEquipment.CreatedBy = dr.GetString(dr.GetOrdinal("CreatedBy"));
wTEquipment.ModifiedBy = dr.GetString(dr.GetOrdinal("ModifiedBy"));
return(wTEquipment);
}
public static int Save(WaterTreatmentEquipment wte)
{
return(WTEDB.Save(wte));
}
