protected void Page_Load(object sender, EventArgs e)
{
string activityTypeID = Request.QueryString["activityTypeID"] as string;
string userTypeID = Request.QueryString["userTypeID"] as string;
if (activityTypeID == null || userTypeID == null)
{
Response.Redirect("Z_ActivityUserTypeDefault.aspx");
}
try
{
activityUserTypeActivityTypeID = Convert.ToInt32(activityTypeID.Trim());
activityUserTypeUserTypeID = Convert.ToInt32(userTypeID.Trim());
activityUserTypeHandler = new ActivityUserTypeHandler();
ActivityUserType activityUserType = activityUserTypeHandler.GetDetails(activityUserTypeActivityTypeID, activityUserTypeUserTypeID);
lblActivityTypeID.Text = activityUserType.ActivityTypeID.ToString();
lblUserTypeID.Text = activityUserType.UserTypeID.ToString();
lblActivityTypeIDTitle.Text = activityUserType.ActivityTypeIDTitle.ToString();
lblUserTypeIDTitle.Text = activityUserType.UserTypeIDTitle.ToString();
}
catch (Exception)
{
Response.Redirect("Z_ActivityUserTypeDefault.aspx");
}
}
public List <ActivityUserType> GetListActivityUserType(int activityTypeID)
{
List <ActivityUserType> listActivityUserType = new List <ActivityUserType>()
{
};
SqlParameter[] parametersActivityType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityTypeID)
};
//Lets get the list of ActivityUserType records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ActivityUserType_GetList_UseInActivityType", CommandType.StoredProcedure, parametersActivityType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of activityUserType
listActivityUserType = new List <ActivityUserType>();
//Now lets populate the ActivityUserType details into the list of activityUserTypes
foreach (DataRow row in table.Rows)
{
ActivityUserType activityUserType = ConvertRowToActivityUserType(row);
listActivityUserType.Add(activityUserType);
}
}
}
return(listActivityUserType);
}
public List <ActivityUserType> SearchLike(ActivityUserType activityUserType)
{
List <ActivityUserType> listActivityUserType = new List <ActivityUserType>();
SqlParameter[] parametersActivityUserType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityUserType.ActivityTypeID),
new SqlParameter("@UserTypeID", activityUserType.UserTypeID),
new SqlParameter("@ActivityTypeIDTitle", activityUserType.ActivityTypeIDTitle),
new SqlParameter("@UserTypeIDTitle", activityUserType.UserTypeIDTitle),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ActivityUserType_SearchLike", CommandType.StoredProcedure, parametersActivityUserType))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
ActivityUserType tmpActivityUserType = new ActivityUserType();
tmpActivityUserType.ActivityTypeID = (row["ActivityTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ActivityTypeID"]) : 0;
tmpActivityUserType.UserTypeID = (row["UserTypeID"] != DBNull.Value) ? Convert.ToInt32(row["UserTypeID"]) : 0;
tmpActivityUserType.ActivityTypeIDTitle = row["ActivityTypeIDTitle"].ToString();
tmpActivityUserType.UserTypeIDTitle = row["UserTypeIDTitle"].ToString();
listActivityUserType.Add(tmpActivityUserType);
}
}
}
return(listActivityUserType);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblActivityTypeID = GridView1.Rows[e.RowIndex].FindControl("lblActivityTypeID") as Label;
Label lblUserTypeID = GridView1.Rows[e.RowIndex].FindControl("lblUserTypeID") as Label;
Label lblActivityTypeIDTitle = GridView1.Rows[e.RowIndex].FindControl("lblActivityTypeIDTitle") as Label;
Label lblUserTypeIDTitle = GridView1.Rows[e.RowIndex].FindControl("lblUserTypeIDTitle") as Label;
if (lblActivityTypeID != null && lblUserTypeID != null && lblActivityTypeIDTitle != null && lblUserTypeIDTitle != null)
{
ActivityUserType activityUserType = new ActivityUserType();
activityUserType.ActivityTypeID = Convert.ToInt32(lblActivityTypeID.Text.Trim());
activityUserType.UserTypeID = Convert.ToInt32(lblUserTypeID.Text.Trim());
activityUserType.ActivityTypeIDTitle = lblActivityTypeIDTitle.Text;
activityUserType.UserTypeIDTitle = lblUserTypeIDTitle.Text;
//Let us now update the database
if (activityUserTypeHandler.Update(activityUserType) == true)
{
lblResult.Text = "Record Updated Successfully";
}
else
{
lblResult.Text = "Failed to Update record";
}
//end the editing and bind with updated records.
GridView1.EditIndex = -1;
BindData();
}
}
public bool Update(ActivityUserType activityUserType)
{
SqlParameter[] parametersActivityUserType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityUserType.ActivityTypeID),
new SqlParameter("@UserTypeID", activityUserType.UserTypeID)
};
return(SqlDBHelper.ExecuteNonQuery("ActivityUserType_Update", CommandType.StoredProcedure, parametersActivityUserType));
}
public Int64 Insert(ActivityUserType activityUserType)
{
SqlParameter[] parametersActivityUserType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", (activityUserType.ActivityTypeID > 0) ? activityUserType.ActivityTypeID : (object)DBNull.Value),
new SqlParameter("@UserTypeID", (activityUserType.UserTypeID > 0) ? activityUserType.UserTypeID : (object)DBNull.Value)
};
return(SqlDBHelper.ExecuteScalar("ActivityUserType_Insert", CommandType.StoredProcedure, parametersActivityUserType));
}
public bool Exists(ActivityUserType activityUserType)
{
SqlParameter[] parametersActivityUserType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityUserType.ActivityTypeID),
new SqlParameter("@UserTypeID", activityUserType.UserTypeID)
};
return(SqlDBHelper.ExecuteScalar("ActivityUserType_Exists", CommandType.StoredProcedure, parametersActivityUserType) > 0);
}
private ActivityUserType ConvertRowToActivityUserType(DataRow row)
{
ActivityUserType activityUserType = new ActivityUserType();
activityUserType.ActivityTypeID = (row["ActivityTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ActivityTypeID"]) : 0;
activityUserType.UserTypeID = (row["UserTypeID"] != DBNull.Value) ? Convert.ToInt32(row["UserTypeID"]) : 0;
activityUserType.ActivityTypeIDTitle = row["ActivityTypeIDTitle"].ToString();
activityUserType.UserTypeIDTitle = row["UserTypeIDTitle"].ToString();
return(activityUserType);
}
protected void btnYES_Click(object sender, EventArgs e)
{
ActivityUserType activityUserType = new ActivityUserType();
activityUserType.ActivityTypeID = Convert.ToInt32(ddlActivityTypeID.SelectedValue);
activityUserType.UserTypeID = Convert.ToInt32(ddlUserTypeID.SelectedValue);
ActivityUserTypeHandler activityUserTypeHandler = new ActivityUserTypeHandler();
if (activityUserTypeHandler.Insert(activityUserType) > 0)
{
Response.Redirect("Z_ActivityUserTypeDefault.aspx");
}
}
public List <ActivityUserType> GetListAll()
{
List <ActivityUserType> listActivityUserType = null;
using (DataTable table = SqlDBHelper.ExecuteSelectCommand("ActivityUserType_GetListAll", CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
listActivityUserType = new List <ActivityUserType>();
foreach (DataRow row in table.Rows)
{
ActivityUserType activityUserType = new ActivityUserType();
activityUserType.ActivityTypeID = (row["ActivityTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ActivityTypeID"]) : 0;
activityUserType.UserTypeID = (row["UserTypeID"] != DBNull.Value) ? Convert.ToInt32(row["UserTypeID"]) : 0;
activityUserType.ActivityTypeIDTitle = row["ActivityTypeIDTitle"].ToString();
activityUserType.UserTypeIDTitle = row["UserTypeIDTitle"].ToString();
listActivityUserType.Add(activityUserType);
}
}
}
return(listActivityUserType);
}
public ActivityUserType GetDetails(int activityTypeID, int userTypeID)
{
ActivityUserType activityUserType = new ActivityUserType();
SqlParameter[] parametersActivityUserType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityTypeID),
new SqlParameter("@UserTypeID", userTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ActivityUserType_GetDetails", CommandType.StoredProcedure, parametersActivityUserType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
activityUserType.ActivityTypeID = (row["ActivityTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ActivityTypeID"]) : 0;
activityUserType.UserTypeID = (row["UserTypeID"] != DBNull.Value) ? Convert.ToInt32(row["UserTypeID"]) : 0;
activityUserType.ActivityTypeIDTitle = row["ActivityTypeIDTitle"].ToString();
activityUserType.UserTypeIDTitle = row["UserTypeIDTitle"].ToString();
}
}
return(activityUserType);
}
