public static ADLDateTime GetADLDateTimeByID(int id)
{
ADLDateTime aDLDateTime = new ADLDateTime();
SqlADLDateTimeProvider sqlADLDateTimeProvider = new SqlADLDateTimeProvider();
aDLDateTime = sqlADLDateTimeProvider.GetADLDateTimeByID(id);
return aDLDateTime;
}
private void showADLDateTimeData()
{
ADLDateTime aDLDateTime = new ADLDateTime();
aDLDateTime = ADLDateTimeManager.GetADLDateTimeByID(Int32.Parse(Request.QueryString["aDLDateTimeID"]));
txtADLDateTime.Text = aDLDateTime.ADLDateTime;
}
public static ADLDateTime GetADLDateTimeByID(int id)
{
ADLDateTime aDLDateTime = new ADLDateTime();
SqlADLDateTimeProvider sqlADLDateTimeProvider = new SqlADLDateTimeProvider();
aDLDateTime = sqlADLDateTimeProvider.GetADLDateTimeByID(id);
return(aDLDateTime);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ADLDateTime aDLDateTime = new ADLDateTime();
aDLDateTime.ADLDateTime = txtADLDateTime.Text;
int resutl = ADLDateTimeManager.InsertADLDateTime(aDLDateTime);
Response.Redirect("AdminADLDateTimeDisplay.aspx");
}
public int InsertADLDateTime(ADLDateTime aDLDateTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertADLDateTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDateTimeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ADLDateTime", SqlDbType.DateTime).Value = aDLDateTime.ADLDateTimeValue;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@ADLDateTimeID"].Value);
}
}
public bool UpdateADLDateTime(ADLDateTime aDLDateTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLDateTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDateTimeID", SqlDbType.Int).Value = aDLDateTime.ADLDateTimeID;
cmd.Parameters.Add("@ADLDateTime", SqlDbType.DateTime).Value = aDLDateTime.ADLDateTimeValue;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ADLDateTime aDLDateTime = new ADLDateTime();
aDLDateTime = ADLDateTimeManager.GetADLDateTimeByID(Int32.Parse(Request.QueryString["aDLDateTimeID"]));
ADLDateTime tempADLDateTime = new ADLDateTime();
tempADLDateTime.ADLDateTimeID = aDLDateTime.ADLDateTimeID;
tempADLDateTime.ADLDateTime = txtADLDateTime.Text;
bool result = ADLDateTimeManager.UpdateADLDateTime(tempADLDateTime);
Response.Redirect("AdminADLDateTimeDisplay.aspx");
}
public ADLDateTime GetADLDateTimeFromReader(IDataReader reader)
{
try
{
ADLDateTime aDLDateTime = new ADLDateTime
(
(int)reader["ADLDateTimeID"],
(DateTime)reader["ADLDateTime"]
);
return aDLDateTime;
}
catch(Exception ex)
{
return null;
}
}
public ADLDateTime GetADLDateTimeFromReader(IDataReader reader)
{
try
{
ADLDateTime aDLDateTime = new ADLDateTime
(
(int)reader["ADLDateTimeID"],
(DateTime)reader["ADLDateTime"]
);
return(aDLDateTime);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateADLDateTime(ADLDateTime aDLDateTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateADLDateTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDateTimeID", SqlDbType.Int).Value = aDLDateTime.ADLDateTimeID;
cmd.Parameters.Add("@ADLDateTime", SqlDbType.DateTime).Value = aDLDateTime.ADLDateTimeValue;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertADLDateTime(ADLDateTime aDLDateTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertADLDateTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADLDateTimeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ADLDateTime", SqlDbType.DateTime).Value = aDLDateTime.ADLDateTimeValue;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@ADLDateTimeID"].Value;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
lblMsg.Visible = true;
int ADLDateTimeID = 0;
if (ddlExistingRecord.SelectedValue == "0")
{
ADLDateTime aDLDateTime = new ADLDateTime();
aDLDateTime.ADLDateTimeValue = DateTime.Now;
ADLDateTimeID = ADLDateTimeManager.InsertADLDateTime(aDLDateTime);
}
else
{
ADLDateTimeID = int.Parse(ddlExistingRecord.SelectedValue);
ADLHeaderDetailnDateTimeManager.DeleteADLHeaderDetailnDateTimeByADLDateTimeID(ADLDateTimeID);
}
foreach (GridViewRow gvr in gvHeader.Rows)
{
HiddenField hfADLHeaderID = (HiddenField)gvr.FindControl("hfADLHeaderID");
GridView gvDetail = (GridView)gvr.FindControl("gvDetail");
foreach (GridViewRow gvrDetail in gvDetail.Rows)
{
HiddenField hfADLHeaderDetialID = (HiddenField)gvrDetail.FindControl("hfADLHeaderDetialID");
TextBox txtNewStatus = (TextBox)gvrDetail.FindControl("txtNewStatus");
TextBox txtRemark = (TextBox)gvrDetail.FindControl("txtRemark");
DropDownList ddlADLStatusInGrid = (DropDownList)gvrDetail.FindControl("ddlADLStatusInGrid");
RadioButtonList rbtnlADLStatusInGrid = (RadioButtonList)gvrDetail.FindControl("rbtnlADLStatusInGrid");
//if (txtNewStatus.Text != "" || ddlADLStatusInGrid.SelectedValue != "0")
try
{
ADLHeaderDetailnDateTime aDLHeaderDetailnDateTime = new ADLHeaderDetailnDateTime();
aDLHeaderDetailnDateTime.ADLDateTimeID = ADLDateTimeID;
aDLHeaderDetailnDateTime.ADLHeaderDetailID = Int32.Parse(hfADLHeaderDetialID.Value);
aDLHeaderDetailnDateTime.ExtraField1 = (txtNewStatus.Text == "" ? rbtnlADLStatusInGrid.SelectedValue : txtNewStatus.Text);
aDLHeaderDetailnDateTime.ExtraField2 = getLogin().ExtraField4;
aDLHeaderDetailnDateTime.ExtraField3 = txtRemark.Text;
aDLHeaderDetailnDateTime.ExtraField4 = getLogin().LoginID.ToString();
aDLHeaderDetailnDateTime.ExtraField5 = "";
int resutl = ADLHeaderDetailnDateTimeManager.InsertADLHeaderDetailnDateTime(aDLHeaderDetailnDateTime);
}
catch (Exception ex)
{ }
}
}
loadMedicineTimenDateDate();
foreach (GridViewRow gvr in gvHeader.Rows)
{
HiddenField hfADLHeaderID = (HiddenField)gvr.FindControl("hfADLHeaderID");
GridView gvDetail = (GridView)gvr.FindControl("gvDetail");
foreach (GridViewRow gvrDetail in gvDetail.Rows)
{
HiddenField hfADLHeaderDetialID = (HiddenField)gvrDetail.FindControl("hfADLHeaderDetialID");
TextBox txtNewStatus = (TextBox)gvrDetail.FindControl("txtNewStatus");
TextBox txtRemark = (TextBox)gvrDetail.FindControl("txtRemark");
DropDownList ddlADLStatusInGrid = (DropDownList)gvrDetail.FindControl("ddlADLStatusInGrid");
RadioButtonList rbtnlADLStatusInGrid = (RadioButtonList)gvrDetail.FindControl("rbtnlADLStatusInGrid");
txtRemark.Text = "";
rbtnlADLStatusInGrid.SelectedIndex = -1;
}
}
}
public static bool UpdateADLDateTime(ADLDateTime aDLDateTime)
{
SqlADLDateTimeProvider sqlADLDateTimeProvider = new SqlADLDateTimeProvider();
return sqlADLDateTimeProvider.UpdateADLDateTime(aDLDateTime);
}
public static int InsertADLDateTime(ADLDateTime aDLDateTime)
{
SqlADLDateTimeProvider sqlADLDateTimeProvider = new SqlADLDateTimeProvider();
return sqlADLDateTimeProvider.InsertADLDateTime(aDLDateTime);
}
public static bool UpdateADLDateTime(ADLDateTime aDLDateTime)
{
SqlADLDateTimeProvider sqlADLDateTimeProvider = new SqlADLDateTimeProvider();
return(sqlADLDateTimeProvider.UpdateADLDateTime(aDLDateTime));
}
public static int InsertADLDateTime(ADLDateTime aDLDateTime)
{
SqlADLDateTimeProvider sqlADLDateTimeProvider = new SqlADLDateTimeProvider();
return(sqlADLDateTimeProvider.InsertADLDateTime(aDLDateTime));
}
