public static STD_Batch GetSTD_BatchMaxIDByYear(int year)
{
STD_Batch sTD_Batch = new STD_Batch();
SqlSTD_BatchProvider sqlSTD_BatchProvider = new SqlSTD_BatchProvider();
sTD_Batch = sqlSTD_BatchProvider.GetSTD_BatchMaxIDByYear(year);
return sTD_Batch;
}
public static STD_Batch GetSTD_BatchByBatchID(int BatchID)
{
STD_Batch sTD_Batch = new STD_Batch();
SqlSTD_BatchProvider sqlSTD_BatchProvider = new SqlSTD_BatchProvider();
sTD_Batch = sqlSTD_BatchProvider.GetSTD_BatchByBatchID(BatchID);
return sTD_Batch;
}
public static STD_Batch GetCOMN_RowStatusByRowStatusID(int RowStatusID)
{
STD_Batch sTD_Batch = new STD_Batch();
SqlSTD_BatchProvider sqlSTD_BatchProvider = new SqlSTD_BatchProvider();
sTD_Batch = sqlSTD_BatchProvider.GetSTD_BatchByRowStatusID(RowStatusID);
return sTD_Batch;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
STD_Batch sTD_Batch = new STD_Batch ();
sTD_Batch.BatchID= int.Parse(Request.QueryString["ID"].ToString());
sTD_Batch.BatchName= txtBatchName.Text;
sTD_Batch.Year= int.Parse(txtYear.Text);
sTD_Batch.ID= int.Parse(ddlID.SelectedValue);
sTD_Batch.BatchCode= txtBatchCode.Text;
sTD_Batch.ExtraField1= txtExtraField1.Text;
sTD_Batch.ExtraField2= txtExtraField2.Text;
sTD_Batch.ExtraField3= txtExtraField3.Text;
sTD_Batch.ExtraField4= txtExtraField4.Text;
sTD_Batch.ExtraField5= txtExtraField5.Text;
sTD_Batch.AddedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_Batch.AddedDate= DateTime.Now;
sTD_Batch.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_Batch.UpdateDate= DateTime.Now;
sTD_Batch.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue);
bool resutl =STD_BatchManager.UpdateSTD_Batch(sTD_Batch);
Response.Redirect("AdminDisplaySTD_Batch.aspx");
}
public bool UpdateSTD_Batch(STD_Batch sTD_Batch)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_Batch", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BatchID", SqlDbType.Int).Value = sTD_Batch.BatchID;
cmd.Parameters.Add("@BatchName", SqlDbType.NVarChar).Value = sTD_Batch.BatchName;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = sTD_Batch.Year;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = sTD_Batch.ID;
cmd.Parameters.Add("@BatchCode", SqlDbType.NVarChar).Value = sTD_Batch.BatchCode;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_Batch.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_Batch.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_Batch.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_Batch.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_Batch.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_Batch.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_Batch.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Batch.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Batch.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_Batch.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_Batch GetSTD_BatchFromReader1(IDataReader reader)
{
try
{
STD_Batch sTD_Batch = new STD_Batch
(
DataAccessObject.IsNULL<int>(reader["MaxID"])
);
return sTD_Batch;
}
catch (Exception ex)
{
return null;
}
}
public STD_Batch GetSTD_BatchFromReader(IDataReader reader)
{
try
{
STD_Batch sTD_Batch = new STD_Batch
(
DataAccessObject.IsNULL<int>(reader["BatchID"]),
DataAccessObject.IsNULL<string>(reader["BatchName"]),
DataAccessObject.IsNULL<int>(reader["Year"]),
DataAccessObject.IsNULL<int>(reader["ID"]),
DataAccessObject.IsNULL<string>(reader["BatchCode"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return sTD_Batch;
}
catch(Exception ex)
{
return null;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
int year = 0;
year = date.Year;
DataSet batch = STD_BatchManager.GetAllSTD_BatchMaxIDByYearnID(year,int.Parse(txtBatchName.Text));
if (batch.Tables[0].Rows.Count != 0)
{
lblMessage.Text = "Already in Database.";
}
else
{
STD_Batch sTD_Batch = new STD_Batch();
sTD_Batch.BatchName = "Batch - "+txtBatchName.Text;
sTD_Batch.BatchCode = year.ToString().Substring(2, 2) + int.Parse(txtBatchName.Text).ToString("000");
sTD_Batch.ID = int.Parse(txtBatchName.Text);
sTD_Batch.Year = year;
sTD_Batch.ExtraField1 = " ";
sTD_Batch.ExtraField2 = " ";
sTD_Batch.ExtraField3 = " ";
sTD_Batch.ExtraField4 = " ";
sTD_Batch.ExtraField5 = " ";
sTD_Batch.AddedBy = Profile.card_id;
sTD_Batch.AddedDate = DateTime.Now;
sTD_Batch.UpdatedBy = Profile.card_id;
sTD_Batch.UpdateDate = DateTime.Now;
sTD_Batch.RowStatusID = 1;
int resutl = STD_BatchManager.InsertSTD_Batch(sTD_Batch);
Response.Redirect("AdminDisplaySTD_Batch.aspx");
}
//STD_Batch batch = STD_BatchManager.GetSTD_BatchMaxIDByYear(year);
//if (batch.MaxID != 0)
//{
// STD_Batch sTD_Batch = new STD_Batch();
// sTD_Batch.BatchName = txtBatchName.Text;
// sTD_Batch.BatchCode = year.ToString().Substring(2, 2) + batch.MaxID.ToString("000");
// sTD_Batch.ID = batch.MaxID;
// sTD_Batch.Year = year;
// sTD_Batch.ExtraField1 = " ";
// sTD_Batch.ExtraField2 = " ";
// sTD_Batch.ExtraField3 = " ";
// sTD_Batch.ExtraField4 = " ";
// sTD_Batch.ExtraField5 = " ";
// sTD_Batch.AddedBy = Profile.card_id;
// sTD_Batch.AddedDate = DateTime.Now;
// sTD_Batch.UpdatedBy = Profile.card_id;
// sTD_Batch.UpdateDate = DateTime.Now;
// sTD_Batch.RowStatusID = int.Parse(ddlRowStatusID.SelectedValue);
// int resutl = STD_BatchManager.InsertSTD_Batch(sTD_Batch);
// Response.Redirect("AdminDisplaySTD_Batch.aspx");
//}
//else
//{
// STD_Batch sTD_Batch = new STD_Batch();
// // sTD_Batch.BatchID= int.Parse(ddlBatchID.SelectedValue);
// sTD_Batch.BatchName = txtBatchName.Text;
// sTD_Batch.BatchCode = year.ToString().Substring(2, 2) + "001";
// sTD_Batch.ID = 1;
// sTD_Batch.Year = year;
// sTD_Batch.ExtraField1 = " ";
// sTD_Batch.ExtraField2 = " ";
// sTD_Batch.ExtraField3 = " ";
// sTD_Batch.ExtraField4 = " ";
// sTD_Batch.ExtraField5 = " ";
// sTD_Batch.AddedBy = Profile.card_id;
// sTD_Batch.AddedDate = DateTime.Now;
// sTD_Batch.UpdatedBy = Profile.card_id;
// sTD_Batch.UpdateDate = DateTime.Now;
// sTD_Batch.RowStatusID = int.Parse(ddlRowStatusID.SelectedValue);
// int resutl = STD_BatchManager.InsertSTD_Batch(sTD_Batch);
// Response.Redirect("AdminDisplaySTD_Batch.aspx");
//}
}
private void showSTD_BatchData()
{
STD_Batch sTD_Batch = new STD_Batch ();
sTD_Batch = STD_BatchManager.GetSTD_BatchByBatchID(Int32.Parse(Request.QueryString["ID"]));
txtBatchName.Text =sTD_Batch.ID.ToString();
//ddlRowStatusID.SelectedValue =sTD_Batch.RowStatusID.ToString();
}
private void showSTD_BatchData()
{
STD_Batch sTD_Batch = new STD_Batch ();
sTD_Batch = STD_BatchManager.GetSTD_BatchByBatchID(Int32.Parse(Request.QueryString["ID"]));
txtBatchName.Text =sTD_Batch.BatchName.ToString();
txtYear.Text =sTD_Batch.Year.ToString();
ddlID.SelectedValue =sTD_Batch.ID.ToString();
txtBatchCode.Text =sTD_Batch.BatchCode.ToString();
txtExtraField1.Text =sTD_Batch.ExtraField1.ToString();
txtExtraField2.Text =sTD_Batch.ExtraField2.ToString();
txtExtraField3.Text =sTD_Batch.ExtraField3.ToString();
txtExtraField4.Text =sTD_Batch.ExtraField4.ToString();
txtExtraField5.Text =sTD_Batch.ExtraField5.ToString();
ddlRowStatusID.SelectedValue =sTD_Batch.RowStatusID.ToString();
}
public static int InsertSTD_Batch(STD_Batch sTD_Batch)
{
SqlSTD_BatchProvider sqlSTD_BatchProvider = new SqlSTD_BatchProvider();
return sqlSTD_BatchProvider.InsertSTD_Batch(sTD_Batch);
}
public static bool UpdateSTD_Batch(STD_Batch sTD_Batch)
{
SqlSTD_BatchProvider sqlSTD_BatchProvider = new SqlSTD_BatchProvider();
return sqlSTD_BatchProvider.UpdateSTD_Batch(sTD_Batch);
}
