public bool DeleteMSalesman(MSalesman msalesman)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMSalesman";
cmd.Parameters.AddWithValue("@SalesmanNo", msalesman.SalesmanNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
msalesman.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public bool AddMSalesman(MSalesman msalesman)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMSalesman";
cmd.Parameters.AddWithValue("@SalesmanNo", msalesman.SalesmanNo);
cmd.Parameters.AddWithValue("@SalesmanName", msalesman.SalesmanName);
cmd.Parameters.AddWithValue("@SalesmanUserNo", msalesman.SalesmanUserNo);
cmd.Parameters.AddWithValue("@Address", msalesman.Address);
cmd.Parameters.AddWithValue("@PinCode", msalesman.PinCode);
cmd.Parameters.AddWithValue("@PhoneNo", msalesman.PhoneNo);
cmd.Parameters.AddWithValue("@Mobile", msalesman.Mobile);
cmd.Parameters.AddWithValue("@Disc", msalesman.Disc);
cmd.Parameters.AddWithValue("@Rupees", msalesman.Rupees);
cmd.Parameters.AddWithValue("@IsActive", msalesman.IsActive);
cmd.Parameters.AddWithValue("@UserID", msalesman.UserID);
cmd.Parameters.AddWithValue("@UserDate", msalesman.UserDate);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
msalesman.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public MSalesman ModifyMSalesmanByID(long ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from MSalesman where SalesmanNo =" + 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)
{
MSalesman MM = new MSalesman();
while (dr.Read())
{
MM.SalesmanNo = Convert.ToInt32(dr["SalesmanNo"]);
if (!Convert.IsDBNull(dr["SalesmanName"]))
{
MM.SalesmanName = Convert.ToString(dr["SalesmanName"]);
}
if (!Convert.IsDBNull(dr["SalesmanUserNo"]))
{
MM.SalesmanUserNo = Convert.ToInt64(dr["SalesmanUserNo"]);
}
if (!Convert.IsDBNull(dr["Address"]))
{
MM.Address = Convert.ToString(dr["Address"]);
}
if (!Convert.IsDBNull(dr["PinCode"]))
{
MM.PinCode = Convert.ToString(dr["PinCode"]);
}
if (!Convert.IsDBNull(dr["PhoneNo"]))
{
MM.PhoneNo = Convert.ToString(dr["PhoneNo"]);
}
if (!Convert.IsDBNull(dr["Mobile"]))
{
MM.Mobile = Convert.ToString(dr["Mobile"]);
}
if (!Convert.IsDBNull(dr["Disc"]))
{
MM.Disc = Convert.ToDouble(dr["Disc"]);
}
if (!Convert.IsDBNull(dr["Rupees"]))
{
MM.Rupees = Convert.ToDouble(dr["Rupees"]);
}
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 MSalesman());
}
