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)); }