public bool AddMPayTypeDetails(MPayTypeDetails mpaytypedetails)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMPayTypeDetails";
cmd.Parameters.AddWithValue("@PKPayTypeDetailsNo", mpaytypedetails.PKPayTypeDetailsNo);
cmd.Parameters.AddWithValue("@FKPayTypeNo", mpaytypedetails.FKPayTypeNo);
cmd.Parameters.AddWithValue("@ColLabel", mpaytypedetails.ColLabel);
cmd.Parameters.AddWithValue("@ColName", mpaytypedetails.ColName);
cmd.Parameters.AddWithValue("@IsComplsory", mpaytypedetails.IsComplsory);
cmd.Parameters.AddWithValue("@IsActive", mpaytypedetails.IsActive);
cmd.Parameters.AddWithValue("@UserID", mpaytypedetails.UserID);
cmd.Parameters.AddWithValue("@UserDate", mpaytypedetails.UserDate);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mpaytypedetails.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public bool DeleteMPayTypeDetails(MPayTypeDetails mpaytypedetails)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMPayTypeDetails";
cmd.Parameters.AddWithValue("@PKPayTypeDetailsNo", mpaytypedetails.PKPayTypeDetailsNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mpaytypedetails.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public MPayTypeDetails ModifyMPayTypeDetailsByID(int ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from MPayTypeDetails where PKPayTypeDetailsNo =" + ID;
cmd = new SqlCommand(sql, Con);
cmd.Connection = Con;
Con.Open();
cmd.CommandType = CommandType.Text;
SqlDataReader dr;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.HasRows)
{
MPayTypeDetails MM = new MPayTypeDetails();
while (dr.Read())
{
MM.PKPayTypeDetailsNo = Convert.ToInt32(dr["PKPayTypeDetailsNo"]);
if (!Convert.IsDBNull(dr["FKPayTypeNo"]))
{
MM.FKPayTypeNo = Convert.ToInt64(dr["FKPayTypeNo"]);
}
if (!Convert.IsDBNull(dr["ColLabel"]))
{
MM.ColLabel = Convert.ToString(dr["ColLabel"]);
}
if (!Convert.IsDBNull(dr["ColName"]))
{
MM.ColName = Convert.ToString(dr["ColName"]);
}
if (!Convert.IsDBNull(dr["IsComplsory"]))
{
MM.IsComplsory = Convert.ToBoolean(dr["IsComplsory"]);
}
if (!Convert.IsDBNull(dr["IsActive"]))
{
MM.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
if (!Convert.IsDBNull(dr["UserID"]))
{
MM.UserID = Convert.ToInt64(dr["UserID"]);
}
if (!Convert.IsDBNull(dr["UserDate"]))
{
MM.UserDate = Convert.ToDateTime(dr["UserDate"]);
}
if (!Convert.IsDBNull(dr["ModifiedBy"]))
{
MM.ModifiedBy = Convert.ToString(dr["ModifiedBy"]);
}
}
dr.Close();
return(MM);
}
else
{
dr.Close();
}
return(new MPayTypeDetails());
}
