protected void BindDropRequestType()
{
objRequestType = objRequestType.Get_By_id(2);
colRequesttype.Add(objRequestType);
drpRequestType.DataTextField = "requesttypename";
drpRequestType.DataValueField = "requesttypeid";
drpRequestType.DataSource = colRequesttype;
drpRequestType.DataBind();
}
string GetRequestTypeName(int requesttypeid)
{
string requesttypename = "";
objRequestType = objRequestType.Get_By_id(requesttypeid);
if (objRequestType.Requesttypeid != 0)
{
requesttypename = objRequestType.Requesttypename;
}
return requesttypename;
}
protected void BindDropRequestType()
{
objRequestType = objRequestType.Get_By_id(2);
colRequesttype.Add(objRequestType);
drpRequestType.DataTextField = "requesttypename";
drpRequestType.DataValueField = "requesttypeid";
drpRequestType.DataSource = colRequesttype;
drpRequestType.DataBind();
}
public int Update_RequestType_mst_By_id(RequestType_mst objRequestType)
{
return (int)ExecuteNonQuery(Sp_RequestType_Update, new object[] { objRequestType.Requesttypename, objRequestType.Requesttypeid, objRequestType.Description });
}
public int Insert_RequestType_mst(RequestType_mst objRequestType)
{
return (int)ExecuteNonQuery(Sp_RequestType_Insert, new object[] { objRequestType.Requesttypename, objRequestType.Description });
}
public object GenerateRequestType_mstObject(ref IDataReader returnData)
{
RequestType_mst obj = new RequestType_mst();
while (returnData.Read())
{
obj.Requesttypeid = (int)returnData["Requesttypeid"];
obj.Requesttypename = (string)returnData["Requesttypename"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateRequestType_mstCollection(ref IDataReader returnData)
{
BLLCollection<RequestType_mst> col = new BLLCollection<RequestType_mst>();
while (returnData.Read())
{
RequestType_mst obj = new RequestType_mst();
obj.Requesttypeid = (int)returnData["Requesttypeid"];
obj.Requesttypename = (string)returnData["Requesttypename"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
