public bool AddMPrinter(MPrinter mprinter)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMPrinter";
cmd.Parameters.AddWithValue("@PrinterNo", mprinter.PrinterNo);
cmd.Parameters.AddWithValue("@PrinterName", mprinter.PrinterName);
cmd.Parameters.AddWithValue("@MachineName", mprinter.MachineName);
cmd.Parameters.AddWithValue("@MachineIP", mprinter.MachineIP);
cmd.Parameters.AddWithValue("@IsDefault", mprinter.IsDefault);
cmd.Parameters.AddWithValue("@IsActive", mprinter.IsActive);
cmd.Parameters.AddWithValue("@UserID", mprinter.UserID);
cmd.Parameters.AddWithValue("@UserDate", mprinter.UserDate);
//cmd.Parameters.AddWithValue("@ModifiedBy", mprinter.ModifiedBy);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mprinter.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public bool DeleteMPrinter(MPrinter mprinter)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMPrinter";
cmd.Parameters.AddWithValue("@PrinterNo", mprinter.PrinterNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mprinter.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public MPrinter ModifyMPrinterByID(long ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from MPrinter where PrinterNo =" + 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)
{
MPrinter MM = new MPrinter();
while (dr.Read())
{
MM.PrinterNo = Convert.ToInt32(dr["PrinterNo"]);
if (!Convert.IsDBNull(dr["PrinterName"]))
{
MM.PrinterName = Convert.ToString(dr["PrinterName"]);
}
if (!Convert.IsDBNull(dr["MachineName"]))
{
MM.MachineName = Convert.ToString(dr["MachineName"]);
}
if (!Convert.IsDBNull(dr["MachineIP"]))
{
MM.MachineIP = Convert.ToString(dr["MachineIP"]);
}
if (!Convert.IsDBNull(dr["IsDefault"]))
{
MM.IsDefault = Convert.ToBoolean(dr["IsDefault"]);
}
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 MPrinter());
}
