public static LOCATIONMAPPING GetLOCATIONMAPPINGByID(int id)
{
LOCATIONMAPPING lOCATIONMAPPING = new LOCATIONMAPPING();
SqlLOCATIONMAPPINGProvider sqlLOCATIONMAPPINGProvider = new SqlLOCATIONMAPPINGProvider();
lOCATIONMAPPING = sqlLOCATIONMAPPINGProvider.GetLOCATIONMAPPINGByID(id);
return(lOCATIONMAPPING);
}
private void showLOCATIONMAPPINGData()
{
LOCATIONMAPPING lOCATIONMAPPING = new LOCATIONMAPPING();
lOCATIONMAPPING = LOCATIONMAPPINGManager.GetLOCATIONMAPPINGByID(Int32.Parse(Request.QueryString["lOCATIONMAPPINGID"]));
ddlLOCATION.SelectedValue = lOCATIONMAPPING.LOCATIONID.ToString();
ddlLOCATIONGROUP.SelectedValue = lOCATIONMAPPING.LOCATIONGROUPID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
LOCATIONMAPPING lOCATIONMAPPING = new LOCATIONMAPPING();
lOCATIONMAPPING.ADDEDDATE = DateTime.Now;
lOCATIONMAPPING.LOCATIONID = Int32.Parse(ddlLOCATION.SelectedValue);
lOCATIONMAPPING.LOCATIONGROUPID = Int32.Parse(ddlLOCATIONGROUP.SelectedValue);
int resutl = LOCATIONMAPPINGManager.InsertLOCATIONMAPPING(lOCATIONMAPPING);
//Response.Redirect("AdminLOCATIONMAPPINGDisplay.aspx");
showLOCATIONMAPPINGGrid();
btnClear_Click(this, new EventArgs());
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
LOCATIONMAPPING lOCATIONMAPPING = new LOCATIONMAPPING();
lOCATIONMAPPING = LOCATIONMAPPINGManager.GetLOCATIONMAPPINGByID(Int32.Parse(Request.QueryString["lOCATIONMAPPINGID"]));
LOCATIONMAPPING tempLOCATIONMAPPING = new LOCATIONMAPPING();
tempLOCATIONMAPPING.LOCATIONMAPPINGID = lOCATIONMAPPING.LOCATIONMAPPINGID;
tempLOCATIONMAPPING.ADDEDDATE = DateTime.Now;
tempLOCATIONMAPPING.LOCATIONID = Int32.Parse(ddlLOCATION.SelectedValue);
tempLOCATIONMAPPING.LOCATIONGROUPID = Int32.Parse(ddlLOCATIONGROUP.SelectedValue);
bool result = LOCATIONMAPPINGManager.UpdateLOCATIONMAPPING(tempLOCATIONMAPPING);
Response.Redirect("AdminLOCATIONMAPPINGDisplay.aspx");
}
public int InsertLOCATIONMAPPING(LOCATIONMAPPING lOCATIONMAPPING)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertLOCATIONMAPPING", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@LOCATIONMAPPINGID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ADDEDDATE", SqlDbType.DateTime).Value = lOCATIONMAPPING.ADDEDDATE;
cmd.Parameters.Add("@LOCATIONID", SqlDbType.Int).Value = lOCATIONMAPPING.LOCATIONID;
cmd.Parameters.Add("@LOCATIONGROUPID", SqlDbType.Int).Value = lOCATIONMAPPING.LOCATIONGROUPID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@LOCATIONMAPPINGID"].Value);
}
}
public LOCATIONMAPPING GetLOCATIONMAPPINGFromReader(IDataReader reader)
{
try
{
LOCATIONMAPPING lOCATIONMAPPING = new LOCATIONMAPPING
(
(int)reader["LOCATIONMAPPINGID"],
(DateTime)reader["ADDEDDATE"],
(int)reader["LOCATIONID"],
(int)reader["LOCATIONGROUPID"]
);
return(lOCATIONMAPPING);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateLOCATIONMAPPING(LOCATIONMAPPING lOCATIONMAPPING)
{
SqlLOCATIONMAPPINGProvider sqlLOCATIONMAPPINGProvider = new SqlLOCATIONMAPPINGProvider();
return(sqlLOCATIONMAPPINGProvider.UpdateLOCATIONMAPPING(lOCATIONMAPPING));
}
public static int InsertLOCATIONMAPPING(LOCATIONMAPPING lOCATIONMAPPING)
{
SqlLOCATIONMAPPINGProvider sqlLOCATIONMAPPINGProvider = new SqlLOCATIONMAPPINGProvider();
return(sqlLOCATIONMAPPINGProvider.InsertLOCATIONMAPPING(lOCATIONMAPPING));
}
