public static INV_MRRInfoMaster GetINV_StoreByStoreID(int StoreID)
{
INV_MRRInfoMaster iNV_MRRInfoMaster = new INV_MRRInfoMaster();
SqlINV_MRRInfoMasterProvider sqlINV_MRRInfoMasterProvider = new SqlINV_MRRInfoMasterProvider();
iNV_MRRInfoMaster = sqlINV_MRRInfoMasterProvider.GetINV_MRRInfoMasterByStoreID(StoreID);
return iNV_MRRInfoMaster;
}
public static INV_MRRInfoMaster GetSTD_CampusByCampusID(int CampusID)
{
INV_MRRInfoMaster iNV_MRRInfoMaster = new INV_MRRInfoMaster();
SqlINV_MRRInfoMasterProvider sqlINV_MRRInfoMasterProvider = new SqlINV_MRRInfoMasterProvider();
iNV_MRRInfoMaster = sqlINV_MRRInfoMasterProvider.GetINV_MRRInfoMasterByCampusID(CampusID);
return iNV_MRRInfoMaster;
}
public static INV_MRRInfoMaster GetINV_MRRInfoMasterByMRRInfoMasterID(int MRRInfoMasterID)
{
INV_MRRInfoMaster iNV_MRRInfoMaster = new INV_MRRInfoMaster();
SqlINV_MRRInfoMasterProvider sqlINV_MRRInfoMasterProvider = new SqlINV_MRRInfoMasterProvider();
iNV_MRRInfoMaster = sqlINV_MRRInfoMasterProvider.GetINV_MRRInfoMasterByMRRInfoMasterID(MRRInfoMasterID);
return iNV_MRRInfoMaster;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
INV_MRRInfoMaster iNV_MRRInfoMaster = new INV_MRRInfoMaster();
iNV_MRRInfoMaster.MRRInfoMasterID = int.Parse(Request.QueryString["ID"].ToString());
iNV_MRRInfoMaster.MRRInfoMasterName = txtMRRInfoMasterName.Text;
iNV_MRRInfoMaster.CampusID = int.Parse(ddlCampusID.SelectedValue);
iNV_MRRInfoMaster.MRRCode = txtMRRCode.Text;
iNV_MRRInfoMaster.MRRDate = DateTime.Parse(txtMRRDate.Text);
iNV_MRRInfoMaster.StoreID = int.Parse(ddlStoreID.SelectedValue);
bool resutl = INV_MRRInfoMasterManager.UpdateINV_MRRInfoMaster(iNV_MRRInfoMaster);
}
catch (Exception ex) { } Response.Redirect("AdminDisplayINV_MRRInfoMaster.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
INV_MRRInfoMaster iNV_MRRInfoMaster = new INV_MRRInfoMaster();
// iNV_MRRInfoMaster.MRRInfoMasterID= int.Parse(ddlMRRInfoMasterID.SelectedValue);
iNV_MRRInfoMaster.MRRInfoMasterName = txtMRRInfoMasterName.Text;
iNV_MRRInfoMaster.CampusID = int.Parse(ddlCampusID.SelectedValue);
iNV_MRRInfoMaster.MRRCode = txtMRRCode.Text;
iNV_MRRInfoMaster.MRRDate = DateTime.Parse(txtMRRDate.Text);
iNV_MRRInfoMaster.StoreID = int.Parse(ddlStoreID.SelectedValue);
int resutl = INV_MRRInfoMasterManager.InsertINV_MRRInfoMaster(iNV_MRRInfoMaster);
}
catch (Exception ex) { } Response.Redirect("AdminDisplayINV_MRRInfoMaster.aspx");
}
public static int InsertINV_MRRInfoMaster(INV_MRRInfoMaster iNV_MRRInfoMaster)
{
SqlINV_MRRInfoMasterProvider sqlINV_MRRInfoMasterProvider = new SqlINV_MRRInfoMasterProvider();
return sqlINV_MRRInfoMasterProvider.InsertINV_MRRInfoMaster(iNV_MRRInfoMaster);
}
public static bool UpdateINV_MRRInfoMaster(INV_MRRInfoMaster iNV_MRRInfoMaster)
{
SqlINV_MRRInfoMasterProvider sqlINV_MRRInfoMasterProvider = new SqlINV_MRRInfoMasterProvider();
return sqlINV_MRRInfoMasterProvider.UpdateINV_MRRInfoMaster(iNV_MRRInfoMaster);
}
private void showINV_MRRInfoMasterData()
{
INV_MRRInfoMaster iNV_MRRInfoMaster = new INV_MRRInfoMaster();
iNV_MRRInfoMaster = INV_MRRInfoMasterManager.GetINV_MRRInfoMasterByMRRInfoMasterID(Int32.Parse(Request.QueryString["ID"]));
txtMRRInfoMasterName.Text = iNV_MRRInfoMaster.MRRInfoMasterName.ToString();
ddlCampusID.SelectedValue = iNV_MRRInfoMaster.CampusID.ToString();
txtMRRCode.Text = iNV_MRRInfoMaster.MRRCode.ToString();
txtMRRDate.Text = iNV_MRRInfoMaster.MRRDate.ToString("dd MMM yyyy");
ddlStoreID.SelectedValue = iNV_MRRInfoMaster.StoreID.ToString();
}
public bool UpdateINV_MRRInfoMaster(INV_MRRInfoMaster iNV_MRRInfoMaster)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateINV_MRRInfoMaster", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MRRInfoMasterID", SqlDbType.Int).Value = iNV_MRRInfoMaster.MRRInfoMasterID;
cmd.Parameters.Add("@MRRInfoMasterName", SqlDbType.NVarChar).Value = iNV_MRRInfoMaster.MRRInfoMasterName;
cmd.Parameters.Add("@CampusID", SqlDbType.Int).Value = iNV_MRRInfoMaster.CampusID;
cmd.Parameters.Add("@MRRCode", SqlDbType.NVarChar).Value = iNV_MRRInfoMaster.MRRCode;
cmd.Parameters.Add("@MRRDate", SqlDbType.DateTime).Value = iNV_MRRInfoMaster.MRRDate;
cmd.Parameters.Add("@StoreID", SqlDbType.Int).Value = iNV_MRRInfoMaster.StoreID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public INV_MRRInfoMaster GetINV_MRRInfoMasterFromReader(IDataReader reader)
{
try
{
INV_MRRInfoMaster iNV_MRRInfoMaster = new INV_MRRInfoMaster
(
DataAccessObject.IsNULL<int>(reader["MRRInfoMasterID"]),
DataAccessObject.IsNULL<string>(reader["MRRInfoMasterName"]),
DataAccessObject.IsNULL<int>(reader["CampusID"]),
DataAccessObject.IsNULL<string>(reader["MRRCode"]),
DataAccessObject.IsNULL<DateTime>(reader["MRRDate"]),
DataAccessObject.IsNULL<int>(reader["StoreID"])
);
return iNV_MRRInfoMaster;
}
catch(Exception ex)
{
return null;
}
}
