internal DataTable FillTransportation(SalesReturnModel objSalesRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objSalesRModel.Ind);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSalesReturn);
dtSalesReturn.TableName = "success";
}
catch (Exception)
{
dtSalesReturn = new DataTable();
dtSalesReturn.TableName = "error";
return(dtSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSalesReturn);
}
public HttpResponseMessage UpdateSalesReturn(SalesReturnModel _SalesReturnModel)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
var re = (from a in db.TBL_SALES_RETURN where a.SALES_RETURN_ID == _SalesReturnModel.SALES_RETURN_ID select a).FirstOrDefault();
re.BUSINESS_LOCATION = _SalesReturnModel.BUSINESS_LOCATION;
re.SALES_RETURN_NO = _SalesReturnModel.SALES_RETURN_NO;
re.BARCODE = _SalesReturnModel.BARCODE;
re.ITEM_NAME = _SalesReturnModel.ITEM_NAME;
re.IS_WITHOUT_INVOICE = _SalesReturnModel.IS_WITHOUT_INVOICE;
re.RETURN_DATE = System.DateTime.Now;
re.GODOWN = _SalesReturnModel.GODOWN;
re.CUSTOMER_ID = _SalesReturnModel.CUSTOMER_ID;
re.OUTSTANDING_BALANCE = _SalesReturnModel.OUTSTANDING_BALANCE;
re.INVOICE_NO = _SalesReturnModel.INVOICE_NO;
re.REFERENCE_NUMBER = _SalesReturnModel.REFERENCE_NUMBER;
re.TAX_AMOUNT = _SalesReturnModel.TAX_AMOUNT;
re.FREIGHT_CHARGE = _SalesReturnModel.FREIGHT_CHARGE;
re.PACKING_CHARGE = _SalesReturnModel.PACKING_CHARGE;
re.TOTAL_AMOUNT = _SalesReturnModel.TOTAL_AMOUNT;
re.ROUND_OFF_AMOUNT = _SalesReturnModel.ROUND_OFF_AMOUNT;
re.GRAND_TOTAL = _SalesReturnModel.GRAND_TOTAL;
re.COMPANY_ID = _SalesReturnModel.COMPANY_ID;
re.SUBSIDY_AMOUN = _SalesReturnModel.SUBSIDY_AMOUN;
re.CUS_PENDING_AMOUNT = _SalesReturnModel.CUS_PENDING_AMOUNT;
re.NOTES = _SalesReturnModel.NOTES;
re.SEARCH_CODE = _SalesReturnModel.SEARCH_CODE;
re.SALES_EXECUTIVE = _SalesReturnModel.SALES_EXECUTIVE;
re.IS_DELETE = false;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, re));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
internal DataTable FillItemSellingRate(SalesReturnModel objSalesRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objSalesRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSalesRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objSalesRModel.BrID);
//ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSalesRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objSalesRModel.PartyCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objSalesRModel.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", objSalesRModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@ByCash", objSalesRModel.ByCashSale);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSalesReturn);
dtSalesReturn.TableName = "success";
}
catch (Exception)
{
dtSalesReturn = new DataTable();
dtSalesReturn.TableName = "error";
return(dtSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSalesReturn);
}
internal DataTable FillShippingAddress(SalesReturnModel objSalesRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objSalesRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSalesRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objSalesRModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSalesRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objSalesRModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objSalesRModel.GSTIN);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSalesReturn);
dtSalesReturn.TableName = "success";
}
catch (Exception)
{
dtSalesReturn = new DataTable();
dtSalesReturn.TableName = "error";
return(dtSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSalesReturn);
}
internal DataSet LoadSRBasicDetails(SalesReturnModel objSalesRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSalesReturnVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objSalesRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSalesRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objSalesRModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSalesRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", objSalesRModel.InvoiceSeries);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceNo", objSalesRModel.InvoiceNo);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsSalesReturn = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsSalesReturn);
dsSalesReturn.DataSetName = "success";
}
catch (Exception)
{
dsSalesReturn = new DataSet();
dsSalesReturn.DataSetName = "error";
return(dsSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsSalesReturn);
}
internal DataTable LastVoucherNo(SalesReturnModel objSalesRModel) // Pending
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objSalesRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSalesRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objSalesRModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSalesRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objSalesRModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSalesReturn);
dtSalesReturn.TableName = "success";
}
catch (Exception)
{
dtSalesReturn = new DataTable();
dtSalesReturn.TableName = "error";
return(dtSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSalesReturn);
}
public DataTable FillShippingAddress(SalesReturnModel objSalesRModel)
{
DataTable ItemList = objSalesRDA.FillShippingAddress(objSalesRModel);
return(ItemList);
}
public DataTable FillItemSellingRate(SalesReturnModel objSalesRModel)
{
DataTable ItemList = objSalesRDA.FillItemSellingRate(objSalesRModel);
return(ItemList);
}
public DataTable FillItemName(SalesReturnModel objSalesRModel)
{
DataTable dtFillItemName = objSalesRDA.FillItemName(objSalesRModel);
return(dtFillItemName);
}
public HttpResponseMessage CreateSalesReturn(SalesReturnModel _SalesReturnModel)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
TBL_SALES_RETURN re = new TBL_SALES_RETURN();
re.BUSINESS_LOCATION = _SalesReturnModel.BUSINESS_LOCATION;
re.SALES_RETURN_NO = _SalesReturnModel.SALES_RETURN_NO;
re.BARCODE = _SalesReturnModel.BARCODE;
re.ITEM_NAME = _SalesReturnModel.ITEM_NAME;
re.IS_WITHOUT_INVOICE = _SalesReturnModel.IS_WITHOUT_INVOICE;
re.RETURN_DATE = System.DateTime.Now;
re.GODOWN = _SalesReturnModel.GODOWN;
re.CUSTOMER_ID = _SalesReturnModel.CUSTOMER_ID;
re.OUTSTANDING_BALANCE = _SalesReturnModel.OUTSTANDING_BALANCE;
re.INVOICE_NO = _SalesReturnModel.INVOICE_NO;
re.REFERENCE_NUMBER = _SalesReturnModel.REFERENCE_NUMBER;
re.TAX_AMOUNT = _SalesReturnModel.TAX_AMOUNT;
re.FREIGHT_CHARGE = _SalesReturnModel.FREIGHT_CHARGE;
re.PACKING_CHARGE = _SalesReturnModel.PACKING_CHARGE;
re.TOTAL_AMOUNT = _SalesReturnModel.TOTAL_AMOUNT;
re.ROUND_OFF_AMOUNT = _SalesReturnModel.ROUND_OFF_AMOUNT;
re.GRAND_TOTAL = _SalesReturnModel.GRAND_TOTAL;
re.COMPANY_ID = _SalesReturnModel.COMPANY_ID;
re.SUBSIDY_AMOUN = _SalesReturnModel.SUBSIDY_AMOUN;
re.CUS_PENDING_AMOUNT = _SalesReturnModel.CUS_PENDING_AMOUNT;
re.NOTES = _SalesReturnModel.NOTES;
re.SEARCH_CODE = _SalesReturnModel.SEARCH_CODE;
re.SALES_EXECUTIVE = _SalesReturnModel.SALES_EXECUTIVE;
re.IS_DELETE = false;
db.TBL_SALES_RETURN.Add(re);
db.SaveChanges();
var str = (from a in db.TBL_INVOICE_PAY where a.INVOICE_NO == re.INVOICE_NO select a).FirstOrDefault();
if (str != null)
{
str.STATUS = "Cancelled";
str.SALES_RETURN_AMOUNT = re.GRAND_TOTAL;
//str.QUANTITY_TOTAL = str.QUANTITY_TOTAL-_SalesReturnModel.TOTAL_QTY;
//str.NUMBER_OF_ITEM = str.NUMBER_OF_ITEM-_SalesReturnModel.TOTAL_ITEM;
db.SaveChanges();
}
var strcash = (from a in db.TBL_NEWCASHREGISTER where a.IS_MAIN_CASH == true select a).FirstOrDefault();
if (strcash != null)
{
strcash.CASH_AMOUNT = strcash.CASH_AMOUNT - re.GRAND_TOTAL;
db.SaveChanges();
}
if (_SalesReturnModel.SelectedItem.Count > 0)
{
foreach (var item in _SalesReturnModel.SelectedItem)
{
var obj = (from a in db.TBL_SALE_ITEM where a.INVOICE_ID == item.INVOICE_ID && a.SALE_ID == item.SALE_ID select a).FirstOrDefault();
if (obj != null)
{
obj.STATUS = false;
// db.SaveChanges();
}
var ob = (from a in db.TBL_ITEMS where a.BARCODE == item.BARCODE && a.ITEM_NAME == item.ITEM_NAME select a).FirstOrDefault();
if (ob != null)
{
ob.OPN_QNT = ob.OPN_QNT + item.Current_Qty;
//db.SaveChanges();
}
var st = (from a in db.TBL_OPENING_STOCK where a.BARCODE == item.BARCODE && a.ITEM_NAME == item.ITEM_NAME select a).FirstOrDefault();
if (st != null)
{
st.OPN_QNT = st.OPN_QNT + item.Current_Qty;
//db.SaveChanges();
}
db.SaveChanges();
}
}
return(Request.CreateResponse(HttpStatusCode.OK, "success"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
public DataTable SaveSalesReturnVoucher(SalesReturnModel objSalesRModel)
{
DataTable AccHeadList = objSalesRDA.SaveSalesReturnVoucher(objSalesRModel);
return(AccHeadList);
}
public DataSet FillItemSellRate(SalesReturnModel objSalesRModel)
{
DataSet ItemList = objSalesRDA.FillItemSellRate(objSalesRModel);
return(ItemList);
}
public DataTable InvoiceSeries(SalesReturnModel objSalesRModel)
{
DataTable dtLastVoucherNo = objSalesRDA.InvoiceSeries(objSalesRModel);
return(dtLastVoucherNo);
}
public DataTable LoadNarration(SalesReturnModel objSalesRModel)
{
DataTable NarrationList = objSalesRDA.LoadNarration(objSalesRModel);
return(NarrationList);
}
internal DataTable SaveSalesReturnVoucher(SalesReturnModel objSalesRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSalesReturnVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objSalesRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSalesRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objSalesRModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSalesRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objSalesRModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", objSalesRModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", objSalesRModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", objSalesRModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", objSalesRModel.ByCashSale);
ClsCon.cmd.Parameters.AddWithValue("@PartyName", objSalesRModel.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", objSalesRModel.PartyGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", objSalesRModel.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", objSalesRModel.WareHouseID);
ClsCon.cmd.Parameters.AddWithValue("@TransName", objSalesRModel.TransName);
ClsCon.cmd.Parameters.AddWithValue("@PONo", objSalesRModel.PONo);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", objSalesRModel.DocDate);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", objSalesRModel.InvoiceSeries);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objSalesRModel.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherNo", objSalesRModel.OrgVoucherNo);
ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherDate", objSalesRModel.OrgVoucherDate);
//ClsCon.cmd.Parameters.AddWithValue("@TblSale", JsonConvert.DeserializeObject<DataTable>(objSalesRModel.DtSales));
//ClsCon.cmd.Parameters.AddWithValue("@TblItems", JsonConvert.DeserializeObject<DataTable>(objSalesRModel.DtItems));
//ClsCon.cmd.Parameters.AddWithValue("@TblSundries", JsonConvert.DeserializeObject<DataTable>(objSalesRModel.DtSundries));
ClsCon.cmd.Parameters.AddWithValue("@TblSale", objSalesRModel.DtSales);
ClsCon.cmd.Parameters.AddWithValue("@TblItems", objSalesRModel.DtItems);
ClsCon.cmd.Parameters.AddWithValue("@TblSundries", objSalesRModel.DtSundries);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSalesReturn);
dtSalesReturn.TableName = "success";
}
catch (Exception)
{
dtSalesReturn = new DataTable();
dtSalesReturn.TableName = "error";
return(dtSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSalesReturn);
}
public DataTable LastVoucherNo(SalesReturnModel objSalesRModel)
{
DataTable AccHeadList = objSalesRDA.LastVoucherNo(objSalesRModel);
return(AccHeadList);
}
public DataTable FillTransportation(SalesReturnModel objSalesRModel)
{
DataTable dtLastVoucherNo = objSalesRDA.FillTransportation(objSalesRModel);
return(dtLastVoucherNo);
}
public DataTable IncomeHead(SalesReturnModel objSalesRModel)
{
DataTable IncomeHeadList = objSalesRDA.LoadIncomeHead(objSalesRModel);
return(IncomeHeadList);
}
public DataSet BindAll(SalesReturnModel objSalesRModel)
{
DataSet dsBindAll = objSalesRDA.BindAll(objSalesRModel);
return(dsBindAll);
}
public DataTable SalesTo(SalesReturnModel objSalesRModel)
{
DataTable dtSalesTo = objSalesRDA.LoadSalesTo(objSalesRModel);
return(dtSalesTo);
}
public DataSet LoadSRBasicDetails(SalesReturnModel objSalesRModel)
{
DataSet dsSRBasicDetails = objSalesRDA.LoadSRBasicDetails(objSalesRModel);
return(dsSRBasicDetails);
}
public DataTable FillLocation(SalesReturnModel objSalesRModel)
{
DataTable dtFillLocation = objSalesRDA.Filllocation(objSalesRModel);
return(dtFillLocation);
}
public ResponseDetail SaveOrderReturn(SalesReturnModel objPartyDispatchOrder)
{
return(objTransacAPI.SaveOrderReturn(objPartyDispatchOrder));
}
public DataTable FillGistnNo(SalesReturnModel objSalesRModel)
{
DataTable IncomeHeadList = objSalesRDA.FillGistnNo(objSalesRModel);
return(IncomeHeadList);
}
