public int Insert_ChangeApprove_trans(ChangeApprove_trans ObjChangeApprovetrans)
{
return (int)ExecuteNonQuery(Sp_ChangeApprove_trans_Insert, new object[] { ObjChangeApprovetrans.Changeid, ObjChangeApprovetrans.ApproverName, ObjChangeApprovetrans.Approvestatus, ObjChangeApprovetrans.Approvalcomment });
}
public CollectionBase GenerateChangeApprove_mstCollection(ref IDataReader returnData)
{
BLLCollection<ChangeApprove_trans> col = new BLLCollection<ChangeApprove_trans>();
while (returnData.Read())
{
ChangeApprove_trans obj = new ChangeApprove_trans();
if (returnData["Approvalcomment"] != DBNull.Value)
{
obj.Approvalcomment = (string)returnData["Approvalcomment"];
}
obj.ApproverName = (string)returnData["ApproverName"];
obj.Approvestatus = (int)returnData["Approvestatus"];
obj.Changeid = (int)returnData["Changeid"];
DateTime Changestatusdate = new DateTime();
if (returnData["Changestatusdatetime"] != DBNull.Value)
{
Changestatusdate = (DateTime)returnData["Changestatusdatetime"];
obj.Changestatusdatetime = Changestatusdate.ToString();
}
// obj.Changestatusdatetime = (string)returnData["Changestatusdatetime"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}