public bool AddCommissionEntry(clsCommission info)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_Add_CommissionEntry"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@RegistrationNo", info.strRegistration);
cmd.Parameters.AddWithValue("@Project", info.strProject);
cmd.Parameters.AddWithValue("@ClientID", info.strClientID);
cmd.Parameters.AddWithValue("@ClientName", info.strClientName);
cmd.Parameters.AddWithValue("@Dealer", info.strDealer);
cmd.Parameters.AddWithValue("@EntryNumber", info.strEntryNumber);
cmd.Parameters.AddWithValue("@EntryType", info.intEntryType);
cmd.Parameters.AddWithValue("@DocumentDate", info.DocumentDate);
cmd.Parameters.AddWithValue("@NetPrice", info.decNetPrice);
cmd.Parameters.AddWithValue("@Percentage", info.decPercentage);
cmd.Parameters.AddWithValue("@Amount", info.decAmount);
cmd.Parameters.AddWithValue("@Remarks", info.strRemarks);
cmd.Parameters.AddWithValue("@SentToGp", info.bSentToGP);
cmd.Parameters.AddWithValue("@id", info.intID);
st = cmd.ExecuteNonQuery();
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <clsCommission> GetAllCommList(clsDocumentFilter clsdoc)
{
List <clsCommission> lst = new List <clsCommission>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetAllCommissionList"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@RegistrationNo", clsdoc.strRegistrationNo);
cmd.Parameters.AddWithValue("@ProjectID", clsdoc.strProjectID);
cmd.Parameters.AddWithValue("@ClientID", clsdoc.strClientID);
cmd.Parameters.AddWithValue("@StartDate", clsdoc.dateStartDate);
cmd.Parameters.AddWithValue("@EndDate", clsdoc.dateEndDate);
cmd.Parameters.AddWithValue("@EntryNumber", clsdoc.strDocNumber);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var info = new clsCommission();
info.strRegistration = reader["RegistrationNo"].ToString();
info.strClientID = reader["ClientID"].ToString();
info.strClientName = reader["ClientName"].ToString();
info.strEntryNumber = reader["EntryNumber"].ToString();
info.DocumentDate = Convert.ToDateTime(reader["DocumentDate"]);
info.decAmount = Convert.ToDecimal(reader["Amount"]);
info.strRemarks = reader["Remarks"].ToString();
info.intID = Convert.ToInt32(reader["id"]);
//RegistrationNo, ClientID, ClientName, EntryNumber, DocumentDate, Amount, Remarks, id
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}
public List <clsCommission> GetUnsentCommissionList()
{
List <clsCommission> lst = new List <clsCommission>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetUnsentToGPCommList"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var entry = new clsCommission();
entry.strRegistration = reader["RegistrationNo"].ToString();
entry.strProject = reader["Project"].ToString();
entry.strClientID = reader["ClientID"].ToString();
entry.strClientName = reader["ClientName"].ToString();
entry.strDealer = reader["Dealer"].ToString();
entry.strEntryNumber = reader["EntryNumber"].ToString();
entry.intEntryType = Convert.ToInt32(reader["EntryType"]);
entry.decNetPrice = Convert.ToDecimal(reader["NetPrice"]);
entry.DocumentDate = Convert.ToDateTime(reader["DocumentDate"]);
entry.decPercentage = Convert.ToDecimal(reader["Percentage"]);
entry.decAmount = Convert.ToDecimal(reader["Amount"]);
entry.strRemarks = reader["Remarks"].ToString();
entry.bSentToGP = Convert.ToBoolean(reader["SentToGp"]);
entry.intID = Convert.ToInt32(reader["id"]);
lst.Add(entry);
}
conn.Close();
}
}
return(lst);
}
public clsCommission GetCommissionEntry(int id)
{
clsCommission entry = new clsCommission();
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetCommEntry"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
conn.Open();
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
entry.strRegistration = reader["RegistrationNo"].ToString();
entry.strProject = reader["Project"].ToString();
entry.strClientID = reader["ClientID"].ToString();
entry.strClientName = reader["ClientName"].ToString();
entry.strDealer = reader["Dealer"].ToString();
entry.strEntryNumber = reader["EntryNumber"].ToString();
entry.intEntryType = Convert.ToInt32(reader["EntryType"]);
entry.decNetPrice = Convert.ToDecimal(reader["NetPrice"]);
entry.DocumentDate = Convert.ToDateTime(reader["DocumentDate"]);
entry.decPercentage = Convert.ToDecimal(reader["Percentage"]);
entry.decAmount = Convert.ToDecimal(reader["Amount"]);
entry.strRemarks = reader["Remarks"].ToString();
entry.bSentToGP = Convert.ToBoolean(reader["SentToGp"]);
entry.intID = Convert.ToInt32(reader["id"]);
}
conn.Close();
}
}
return(entry);
}
