public static Customer CheckCustomer(string username, string passwd)
{
string sql = "select * from customer where userName=@name and pwd=@pwd ";
DBParameterCollection collection = new DBParameterCollection();
DBParameter paramer = new DBParameter();
paramer.DbType = System.Data.DbType.String;
paramer.DbValue = username;
paramer.Name = "@name";
paramer.Size = 40;
paramer.Direction = System.Data.ParameterDirection.Input;
collection.AddDbParameter(paramer);
paramer = new DBParameter();
paramer.DbType = System.Data.DbType.String;
paramer.DbValue = passwd;
paramer.Name = "@pwd";
paramer.Size = 40;
paramer.Direction = System.Data.ParameterDirection.Input;
collection.AddDbParameter(paramer);
var list= responsity.QuerySql<Customer>(sql, collection).ToList();
if (list != null && list.Count > 0)
return list[0];
return null;
}
public static Customer GetCustomer(string userName)
{
string sql = "select * from customer where userName=@name ";
DBParameterCollection collection = new DBParameterCollection();
DBParameter paramer = new DBParameter();
paramer.DbType = System.Data.DbType.String;
paramer.DbValue = userName;
paramer.Name = "@name";
paramer.Size = 40;
paramer.Direction = System.Data.ParameterDirection.Input;
collection.AddDbParameter(paramer);
var rtn = responsity.QuerySql<Customer>(sql, collection);
if (rtn != null && rtn.Count() > 0)
return rtn.ToList<Customer>()[0];
return null;
}
/// <summary>
/// Save Employee
/// </summary>
/// <param name="objEmpMaster"></param>
/// <returns>True/False</returns>
public bool SaveEmployeeMaster(EmployeeMasterModel objEmpMaster)
{
string Query = string.Empty;
DBParameterCollection paramCollection = new DBParameterCollection();
//paramCollection.Add(new DBParameter("@Acc_DbName", "SunSpped"));
paramCollection.Add(new DBParameter("@Emp_NAME", objEmpMaster.EmployeeName));
paramCollection.Add(new DBParameter("@Emp_CODE", objEmpMaster.EmployeeCode));
paramCollection.Add(new DBParameter("@Emp_SHORTNAME", objEmpMaster.ShortName));
paramCollection.Add(new DBParameter("@Emp_PRINTNAME", objEmpMaster.PrintName));
paramCollection.Add(new DBParameter("@Emp_Group", objEmpMaster.Group));
paramCollection.Add(new DBParameter("@Emp_Dest", objEmpMaster.Designation));
paramCollection.Add(new DBParameter("@Emp_Fname", objEmpMaster.FatherName));
paramCollection.Add(new DBParameter("@Emo_Sname", objEmpMaster.SpouseName));
paramCollection.Add(new DBParameter("@Emp_address", objEmpMaster.Address));
paramCollection.Add(new DBParameter("@Emp_address1", objEmpMaster.Address1));
paramCollection.Add(new DBParameter("@Emp_address2", objEmpMaster.Address2));
paramCollection.Add(new DBParameter("@Emp_Address3", objEmpMaster.Address3));
paramCollection.Add(new DBParameter("@Emp_Dob", objEmpMaster.DateofBirth, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Emp_Gender", objEmpMaster.Gender));
paramCollection.Add(new DBParameter("@Emp_MobileNumber", objEmpMaster.MobileNumber));
paramCollection.Add(new DBParameter("@Emp_TelephoneNumber", objEmpMaster.TelephoneNumber));
paramCollection.Add(new DBParameter("@Emp_email", objEmpMaster.email));
paramCollection.Add(new DBParameter("@Emp_ITPanNumber", objEmpMaster.ITpan));
paramCollection.Add(new DBParameter("@Emp_doj", objEmpMaster.DateofJoining, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Emp_curstatus", objEmpMaster.CurrentStatus));
paramCollection.Add(new DBParameter("@Emp_lastdate", objEmpMaster.LastWorkingDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Emp_pf", objEmpMaster.PFNo));
paramCollection.Add(new DBParameter("@Emp_esi", objEmpMaster.ESIInsurance));
paramCollection.Add(new DBParameter("@Emp_Bonus", objEmpMaster.BonusApplicable));
paramCollection.Add(new DBParameter("@Emp_emailquery", objEmpMaster.EmailQuery));
paramCollection.Add(new DBParameter("@Emp_smsquery", objEmpMaster.SMSQuery));
paramCollection.Add(new DBParameter("@Emp_conta", objEmpMaster.Contactperson));
paramCollection.Add(new DBParameter("@Emp_ward", objEmpMaster.Ward));
paramCollection.Add(new DBParameter("@Emp_lst", objEmpMaster.LSTNo));
paramCollection.Add(new DBParameter("@Emp_cst", objEmpMaster.CSTNo));
paramCollection.Add(new DBParameter("@Emp_tin", objEmpMaster.TIN));
paramCollection.Add(new DBParameter("@Emp_lbt", objEmpMaster.LBTNo));
paramCollection.Add(new DBParameter("@Emp_servicetax", objEmpMaster.ServiceTaxNo));
paramCollection.Add(new DBParameter("@Emp_iecode", objEmpMaster.IECode));
paramCollection.Add(new DBParameter("@Emp_dlno", objEmpMaster.DLNo1));
paramCollection.Add(new DBParameter("@Emp_chPrintname", objEmpMaster.PrintName));
Query =
"INSERT INTO employeemaster (`EmployeeCode`,`Name`,`ShortName`,`PrintName`,`Group`,`Destination`,`FatherName`,`SpouseName`," +
"`Address`,`Address1`,`Address2`,`Address3`,`DateofBirth`,`Gender`,`Mobile`," +
"`Phone`,`Email`,`ITPAN`,`DateofJoin`,`CurrentStatus`,`LastworkingDate`,`PFNo`," +
"`ESINo`,`BonusApplication`,`EmailQuery`,`SMSQuery`,`ContactPerson`,`Ward`,`LSTNo.`,`CSTNo`,`TIN`,`LBTNo`," +
"`ServiceTaxNo`,`IECode`,`DLNo`,`ChequePrintName`)" +
"VALUES(@Emp_CODE,@Emp_NAME,@Emp_SHORTNAME,@Emp_PRINTNAME,@Emp_Group,@Emp_Dest,@Emp_Fname,@Emo_Sname,@Emp_address," +
"@Emp_address1,@Emp_address2,@Emp_address3,@Emp_Dob,@Emp_Gender,@Emp_MobileNumber," +
"@Emp_TelephoneNumber,@Emp_email,@Emp_ITPanNumber,@Emp_doj,@Emp_curstatus,@Emp_lastdate,@Emp_pf," +
"@Emp_esi,@Emp_Bonus,@Emp_emailquery,@Emp_smsquery,@Emp_conta,@Emp_ward,@Emp_lst,@Emp_cst,@Emp_tin,@Emp_lbt," +
"@Emp_servicetax,@Emp_iecode,@Emp_dlno,@Emp_chPrintname)";
return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0);
}
//Update Contra Voucher
public bool UpdateContraVoucher(ContraVoucherModel objContra)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE CONTRA TABLE - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objContra.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objContra.CV_Date));
paramCollection.Add(new DBParameter("@VoucherNumber", objContra.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objContra.Type));
paramCollection.Add(new DBParameter("@CVDate", objContra.CV_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@PDCDate", objContra.PDCDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@TotalCreditAmount", objContra.TotalCreditAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalDebitAmount", objContra.TotalDebitAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@LongNarration", objContra.LongNarration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ContraId", objContra.CV_Id));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spUpdateContraMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
List <AccountModel> lstAcct = new List <AccountModel>();
//UPDATE Contra Voucher details
foreach (AccountModel act in objContra.ContraAccountModel)
{
act.ParentId = Convert.ToInt32(objContra.CV_Id);
if (act.AC_Id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@DebitAmount", act.Debit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreditAmount", act.Credit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", ""));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@AccId", act.AC_Id));
paramCollection.Add(new DBParameter("@ContraId", act.ParentId));
System.Data.IDataReader acdr =
_dbHelper.ExecuteDataReader("spUpdateContraDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ContraID", act.ParentId));
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@DebitAmount", act.Debit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreditAmount", act.Credit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
System.Data.IDataReader acdr =
_dbHelper.ExecuteDataReader("spInsertContraDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
}
}
catch (Exception ex)
{
isUpdated = false;
//throw ex;
}
return(isUpdated);
}
/// <summary>
/// Update Account
/// </summary>
/// <param name="objAcctMaster"></param>
/// <returns>True/False</returns>
public bool UpdateAccount(AccountMasterModel objAcctMaster)
{
string Query = string.Empty;
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Acc_DbName", "zAKIR"));
paramCollection.Add(new DBParameter("@ACC_NAME", objAcctMaster.AccountName));
paramCollection.Add(new DBParameter("@ACC_SHORTNAME", objAcctMaster.ShortName));
paramCollection.Add(new DBParameter("@ACC_PRINTNAME", objAcctMaster.PrintName));
paramCollection.Add(new DBParameter("@ACC_LedgerType", objAcctMaster.LedgerType));
paramCollection.Add(new DBParameter("@ACC_MultiCurr", objAcctMaster.MultiCurrency, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_Group", objAcctMaster.Group));
paramCollection.Add(new DBParameter("@ACC_OpBal", objAcctMaster.OPBal, System.Data.DbType.Int32));
paramCollection.Add(new DBParameter("@ACC_PrevYearBal", objAcctMaster.PrevYearBal));
paramCollection.Add(new DBParameter("@ACC_DrCrOpenBal", objAcctMaster.DrCrOpeningBal));
paramCollection.Add(new DBParameter("@ACC_DrCrPrevBal", objAcctMaster.DrCrOpeningBal));
paramCollection.Add(new DBParameter("@ACC_MaintainBitwise", objAcctMaster.MaintainBillwiseAccounts, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_ActivateInterestCal", objAcctMaster.ActivateInterestCal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_CreditDays", objAcctMaster.CreditDays));
paramCollection.Add(new DBParameter("@ACC_CreditLimit", objAcctMaster.CreditLimit));
paramCollection.Add(new DBParameter("@ACC_TypeofBuissness", objAcctMaster.TypeofBuissness));
paramCollection.Add(new DBParameter("@ACC_Transport", objAcctMaster.Transport));
paramCollection.Add(new DBParameter("@ACC_Station", objAcctMaster.Station));
paramCollection.Add(new DBParameter("@ACC_SpecifyDefaultSaleType", objAcctMaster.specifyDefaultSaleType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_DefaultSaleType", objAcctMaster.DefaultSaleType));
paramCollection.Add(new DBParameter("@ACC_FreezeSaleType", objAcctMaster.FreezeSaleType));
paramCollection.Add(new DBParameter("@ACC_SpecifyDefaultPurType", objAcctMaster.SpecifyDefaultPurType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_DefaultPurcType", objAcctMaster.DefaultPurcType));
paramCollection.Add(new DBParameter("@ACC_LockSalesType", objAcctMaster.LockSalesType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_LockPurcType", objAcctMaster.LockPurchaseType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_address1", objAcctMaster.address1));
paramCollection.Add(new DBParameter("@ACC_address2", objAcctMaster.address2));
paramCollection.Add(new DBParameter("@ACC_Address3", objAcctMaster.address3));
paramCollection.Add(new DBParameter("@ACC_Address4", objAcctMaster.address4));
paramCollection.Add(new DBParameter("@ACC_State", objAcctMaster.State));
paramCollection.Add(new DBParameter("@ACC_TelephoneNumber", objAcctMaster.TelephoneNumber));
paramCollection.Add(new DBParameter("@ACC_Fax", objAcctMaster.Fax));
paramCollection.Add(new DBParameter("@ACC_MobileNumber", objAcctMaster.MobileNumber));
paramCollection.Add(new DBParameter("@ACC_email", objAcctMaster.email));
paramCollection.Add(new DBParameter("@ACC_Website", objAcctMaster.WebSite));
paramCollection.Add(new DBParameter("@ACC_enablemailquery", objAcctMaster.enablemailquery, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_enableSMSquery", objAcctMaster.enableSMSquery, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_contactperson", objAcctMaster.contactperson));
paramCollection.Add(new DBParameter("@ACC_ITPanNumber", objAcctMaster.ITPanNumber));
paramCollection.Add(new DBParameter("@ACC_LSTNumber", objAcctMaster.LstNumber));
paramCollection.Add(new DBParameter("@ACC_CSTNumber", objAcctMaster.CSTNumber));
paramCollection.Add(new DBParameter("@ACC_TIN", objAcctMaster.TIN));
paramCollection.Add(new DBParameter("@ACC_ServiceTax", objAcctMaster.ServiceTaxNumber));
paramCollection.Add(new DBParameter("@ACC_BankAccountNumber", objAcctMaster.BankAccountNumber));
paramCollection.Add(new DBParameter("@ACC_IECode", objAcctMaster.IECode));
paramCollection.Add(new DBParameter("@ACC_CreatedBy", "admin"));
paramCollection.Add(new DBParameter("@ACC_DEFAULT_CHEQUE_FORMAT", ""));
paramCollection.Add(new DBParameter("@ENABLE_CHEQUE_PRINTING", true, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_Cheque_PrintName", objAcctMaster.ChequePrintName));
paramCollection.Add(new DBParameter("@AC_Id", objAcctMaster.AccountId));
//todo: NEED TO FIX UPDATE
Query =
"UPDATE AccountMaster SET [Acc_DbName]=@Acc_DbName,[ACC_NAME]=@ACC_NAME,[ACC_SHORTNAME]=@ACC_SHORTNAME,[ACC_PRINTNAME]=@ACC_PRINTNAME,[ACC_LedgerType]=@ACC_LedgerType,[ACC_MultiCurr]=@ACC_MultiCurr,[ACC_Group]=@ACC_Group,[ACC_OpBal]=@ACC_OpBal," +
"[ACC_PrevYearBal]=@ACC_PrevYearBal,[ACC_DrCrOpenBal]=@ACC_DrCrOpenBal,[ACC_DrCrPrevBal]=@ACC_DrCrPrevBal,[ACC_MaintainBitwise]=@ACC_MaintainBitwise,[ACC_ActivateInterestCal]=@ACC_ActivateInterestCal,[ACC_CreditDays]=@ACC_CreditDays, " +
"[ACC_CreditLimit]=@ACC_CreditLimit,[ACC_TypeofBuissness]=@ACC_TypeofBuissness,[ACC_Transport]=@ACC_Transport,[ACC_Station]=@ACC_Station,[ACC_SpecifyDefaultSaleType]=@ACC_SpecifyDefaultSaleType,[ACC_DefaultSaleType]=@ACC_DefaultSaleType," +
"[ACC_FreezeSaleType]=@ACC_FreezeSaleType,[ACC_SpecifyDefaultPurType]=@ACC_SpecifyDefaultPurType,[ACC_DefaultPurcType]=@ACC_DefaultPurcType,[ACC_LockSalesType]=@ACC_LockSalesType,[ACC_LockPurcType]=@ACC_LockPurcType,[ACC_address1]=@ACC_address1," +
"[ACC_address2]=@ACC_address2,[ACC_Address3]=@ACC_Address3,[ACC_Address4]=@ACC_Address4,[ACC_State]=@ACC_State,[ACC_TelephoneNumber]=@ACC_TelephoneNumber,[ACC_Fax]=@ACC_Fax,[ACC_MobileNumber]=@ACC_MobileNumber,[ACC_email]=@ACC_email,[ACC_Website]=@ACC_Website," +
"[ACC_enablemailquery]=@ACC_enablemailquery,[ACC_enableSMSquery]=@ACC_enableSMSquery,[ACC_contactperson]=@ACC_contactperson,[ACC_ITPanNumber]=@ACC_ITPanNumber,[ACC_LSTNumber]=@ACC_LSTNumber,[ACC_CSTNumber]=@ACC_CSTNumber,[ACC_TIN]=@ACC_TIN," +
"[ACC_ServiceTax]=@ACC_ServiceTax,[ACC_BankAccountNumber]=@ACC_BankAccountNumber,[ACC_IECode]=@ACC_IECode,[ACC_CreatedBy]=@ACC_CreatedBy,[ACC_DEFAULT_CHEQUE_FORMAT]=@ACC_DEFAULT_CHEQUE_FORMAT,[ENABLE_CHEQUE_PRINTING]=@ENABLE_CHEQUE_PRINTING,[ACC_Cheque_PrintName]=@ACC_Cheque_PrintName " +
" WHERE [AC_Id]=@Ac_Id";
return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0);
}
//Update Purchase Return Details
public bool UpdatePurchaseReturn(eSunSpeedDomain.PurchaseReturnVoucherModel objPurc)
{
string Query = string.Empty;
bool isUpdate = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@PR_Id", objPurc.PR_Id));
paramCollection.Add(new DBParameter("@VoucherType", objPurc.VoucherType));
paramCollection.Add(new DBParameter("@PurcDate", objPurc.PR_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Terms", objPurc.Terms));
paramCollection.Add(new DBParameter("@VoucherNumber", objPurc.VoucherNumber));
paramCollection.Add(new DBParameter("@BillNumber", objPurc.BillNo));
paramCollection.Add(new DBParameter("@LedgerId", objPurc.LedgerId));
paramCollection.Add(new DBParameter("@PurcType", objPurc.PurchaseType));
paramCollection.Add(new DBParameter("@MatCentre", objPurc.MatCenter));
paramCollection.Add(new DBParameter("@Narration", objPurc.Narration));
paramCollection.Add(new DBParameter("@TotalAmount", objPurc.TotalAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalQty", objPurc.TotalQty, DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalFree", objPurc.TotalFree, DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalBasicAmount", objPurc.TotalBasicAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalDisAmount", objPurc.TotalDisAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalTaxAmount", objPurc.TotalTaxAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@BSTotalAmount", objPurc.BSTotalAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", ""));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spUpdatePurchaseReturnMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
foreach (Item_VoucherModel item in objPurc.Item_Voucher)
{
item.ParentId = objPurc.PR_Id;
if (item.Item_ID > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ParentId", item.ParentId));
paramCollection.Add(new DBParameter("@IId", item.Item_ID));
paramCollection.Add(new DBParameter("@ITM_Id", item.ITM_Id));
paramCollection.Add(new DBParameter("@Qty", item.Qty, DbType.Decimal));
paramCollection.Add(new DBParameter("@Unit", item.Unit));
paramCollection.Add(new DBParameter("@Per", item.Per));
paramCollection.Add(new DBParameter("@Price", item.Price, DbType.Decimal));
paramCollection.Add(new DBParameter("@Batch", item.Batch));
paramCollection.Add(new DBParameter("@Free", item.Free, DbType.Decimal));
paramCollection.Add(new DBParameter("@BasicAmt", item.BasicAmt, DbType.Decimal));
paramCollection.Add(new DBParameter("@DiscountPercentage", item.DiscountPercentage, DbType.Decimal));
paramCollection.Add(new DBParameter("@DiscountAmount", item.DiscountAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@TaxAmount", item.TaxAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@Amount", item.Amount, DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", ""));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
System.Data.IDataReader drpr =
_dbHelper.ExecuteDataReader("spUpdatePurchaseReturnItemDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ParentId", item.ParentId));
paramCollection.Add(new DBParameter("@ITM_Id", item.ITM_Id));
paramCollection.Add(new DBParameter("@Qty", item.Qty, DbType.Decimal));
paramCollection.Add(new DBParameter("@Unit", item.Unit));
paramCollection.Add(new DBParameter("@Per", item.Per));
paramCollection.Add(new DBParameter("@Price", item.Price, DbType.Decimal));
paramCollection.Add(new DBParameter("@Batch", item.Batch));
paramCollection.Add(new DBParameter("@Free", item.Free, DbType.Decimal));
paramCollection.Add(new DBParameter("@BasicAmt", item.BasicAmt, DbType.Decimal));
paramCollection.Add(new DBParameter("@DiscountPercentage", item.DiscountPercentage, DbType.Decimal));
paramCollection.Add(new DBParameter("@DiscountAmount", item.DiscountAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@TaxAmount", item.TaxAmount, DbType.Decimal));
paramCollection.Add(new DBParameter("@Amount", item.Amount, DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
System.Data.IDataReader drpr =
_dbHelper.ExecuteDataReader("spInsertPurchaseReturnItemDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
}
foreach (BillSundry_VoucherModel bs in objPurc.BillSundry_Voucher)
{
bs.ParentId = objPurc.PR_Id;
if (bs.BSId > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ParentId", bs.ParentId));
paramCollection.Add(new DBParameter("@BSId", bs.BSId));
paramCollection.Add(new DBParameter("@BS_Id", bs.BS_Id));
paramCollection.Add(new DBParameter("@Percentage", bs.Percentage));
paramCollection.Add(new DBParameter("@Extra", bs.Extra));
paramCollection.Add(new DBParameter("@Amount", bs.Amount));
paramCollection.Add(new DBParameter("@CreatedBy", ""));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
System.Data.IDataReader drbs =
_dbHelper.ExecuteDataReader("spUpdatePurchaseReturnBS", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ParentId", bs.ParentId));
paramCollection.Add(new DBParameter("@BS_Id", bs.BS_Id));
paramCollection.Add(new DBParameter("@Percentage", bs.Percentage));
paramCollection.Add(new DBParameter("@Extra", bs.Extra));
paramCollection.Add(new DBParameter("@Amount", bs.Amount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
System.Data.IDataReader drbS =
_dbHelper.ExecuteDataReader("spInsertPurchaseReturnBS", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
}
}
catch (Exception ex)
{
isUpdate = false;
//throw ex;
}
return(isUpdate);
}
static int Main(string[] args)
{
string exchangeRate = string.Empty;
string dateUpdated = string.Empty;
//Prepare parameters
try
{
foreach (string arg in args)
{
int commandIndex = arg.IndexOf(":");
string command = arg.Substring(0, commandIndex).ToUpper();
switch (command)
{
case "EXCHANGERATE":
exchangeRate = arg.Substring(commandIndex + 1, arg.Length - commandIndex - 1);
break;
case "DATEUPDATED":
dateUpdated = arg.Substring(commandIndex + 1, arg.Length - commandIndex - 1);
break;
default:
// do other stuff...
break;
}
}
}
catch (Exception ex)
{
_logger.Debug(ex);
_logger.ErrorException("[" + DateTime.Now.ToString() + "]", ex);
}
//Start Updating
try
{
_logger.Info("Exchange Rate Started");
var connectionManagerDataSection = ConfigurationManager.GetSection(ConnectionManagerDataSection.SectionName) as ConnectionManagerDataSection;
if (connectionManagerDataSection != null)
{
foreach (ConnectionManagerEndpointElement endpointElement in connectionManagerDataSection.ConnectionManagerEndpoints)
{
if (endpointElement.ExecuteQuery)
{
DBHelper _dbHelper = new DBHelper(endpointElement.Name);
DateTime oDate = Convert.ToDateTime(dateUpdated);
DBParameter param1 = new DBParameter(endpointElement.RateParam, exchangeRate);
DBParameter param2 = new DBParameter(endpointElement.DateParam, oDate.ToString(endpointElement.DateFormat));
DBParameterCollection paramCollection = new DBParameterCollection();
IDbTransaction transaction = _dbHelper.BeginTransaction();
paramCollection.Add(param1);
paramCollection.Add(param2);
string message = "";
string updateCommand = endpointElement.Query;
try
{
message = _dbHelper.ExecuteNonQuery(updateCommand, paramCollection, transaction) > 0 ? "Exchange Rate updated successfully." : "Error in updating record.";
_dbHelper.CommitTransaction(transaction);
_logger.Info(endpointElement.Name + "Database Updated Successfully.");
}
catch (Exception err)
{
_dbHelper.RollbackTransaction(transaction);
}
}
}
}
_logger.Info("Exchange Rate Ended");
return(1);
}
catch (Exception ex)
{
_logger.Info("Exchange Rate Stoped");
_logger.ErrorException("Exception: ", ex);
return(0);
}
}
//UPDATE Debit NOTE
public bool UpdateDebitNote(DebitNoteModel objDebit)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE CREDIT NOTE TABLE - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objDebit.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objDebit.DN_Date));
paramCollection.Add(new DBParameter("@Voucher_Number", objDebit.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objDebit.Type));
paramCollection.Add(new DBParameter("@PDDate", objDebit.PDCDate));
//paramCollection.Add(new DBParameter("@TotalCreditAmt", "0"));
//paramCollection.Add(new DBParameter("@TotalDebitAmt", "0"));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@id", objDebit.DN_Id));
Query = "UPDATE Debit_Note SET [Series]=@Series,[DN_Date]=@Date,[VoucherNo]=@Voucher_Number," +
"[Type]=@Type,[PDC_Date]=@PDDate,[ModifiedBy]=@ModifiedBy," +
"[ModifiedDate]=@ModifiedDate " +
"WHERE Debit_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <AccountModel> lstAcct = new List <AccountModel>();
//UPDATE CREDIT NOTE ACCOUNT -CHILD TABLE UPDATES
foreach (AccountModel act in objDebit.DebitAccountModel)
{
if (act.AC_Id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@Debit", act.Debit));
paramCollection.Add(new DBParameter("@Credit", act.Credit));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@ACT_ID", act.AC_Id));
Query = "UPDATE Debit_Note_Accounts SET [DC]=@DC," +
"[Account]=@Account,[Debit]=@Debit,[Credit]=@Credit,[Narration]=@Narration,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE [AC_Id]=@ACT_ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DN_ID", (act.ParentId)));
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@Debit", act.Debit));
paramCollection.Add(new DBParameter("@Credit", act.Credit));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Debit_Note_Accounts([Debit_Id],[DC],[Account],[Debit],[Credit]," +
"[Narration],[CreatedBy],[CreatedDate]) VALUES " +
"(@DN_ID,@DC,@Account,@Debit,@Credit,@Narration,@CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
}
;
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public DataSet GetAdulterationConfirmationTastQCDetails()
{
DBParameterCollection paramCollection = new DBParameterCollection();
return(_DBHelper.ExecuteDataSet("prod_spGetAdulterationConfirmationTestQCDetails", paramCollection, CommandType.StoredProcedure));
}
public DataSet GetEffluentTreatmentPlantDetails()
{
DBParameterCollection paramcollection = new DBParameterCollection();
return(_DBHelper.ExecuteDataSet("sp_Prod_GetEffluentTreatmentPlantDetails", paramcollection, CommandType.StoredProcedure));
}
public List <ClsUserDetails> SignIn(ClsUserSignIn ObjUser)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@UserCode", ObjUser.User_Code, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@password", ObjUser.Password, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@IsSocialLogin", ObjUser.IsSocialLogin, DbType.Boolean);
ObJParameterCOl.Add(objDBParameter);
DBHelper objDbHelper = new DBHelper();
DataSet ds = objDbHelper.ExecuteDataSet(Constant.SignIn, ObJParameterCOl, CommandType.StoredProcedure);
List <ClsUserDetails> objUserDetails = new List <ClsUserDetails>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
objUserDetails = ds.Tables[0].AsEnumerable().Select(Row =>
new ClsUserDetails
{
Ref_User_ID = Row.Field <Int64>("Ref_User_ID"),
UserCode = Row.Field <string>("UserCode"),
FullName = Row.Field <string>("FullName"),
EmailID = Row.Field <string>("EmailID"),
MobileNumber = Row.Field <string>("MobileNumber"),
Bio = Row.Field <string>("Bio"),
Gender = Row.Field <string>("Gender"),
StudioGears = Row.Field <string>("StudioGears"),
PayPalEmailID = Row.Field <string>("PayPalEmailID"),
SocialProfileUrl = Row.Field <string>("SocialProfileUrl"),
Response = Row.Field <string>("Response"),
FileManager = ds.Tables[1].AsEnumerable().Select(Row2 =>
new ClsFileManager
{
FileManagerID = Row2.Field <Int64>("Ref_FileManager_ID"),
FileIdentifier = Row2.Field <string>("FileIdentifier"),
FileName = Row2.Field <string>("FileName"),
FilePath = Row2.Field <string>("FilePath"),
FileExtension = Row2.Field <string>("FileExtension"),
FileSize = Row2.Field <Int64>("FileSize"),
FileType = Row2.Field <string>("FileType"),
Sequence = Row2.Field <int>("Sequence"),
}).ToList(),
UserMaster = ds.Tables[2].AsEnumerable().Select(Row2 =>
new ClsUserMasterMapping
{
MasterName = Row2.Field <string>("MasterName"),
MasterDataName = Row2.Field <string>("MasterDataName"),
}).ToList(),
}).ToList();
}
}
return(objUserDetails);
}
catch (Exception ex)
{
throw ex;
}
}
public string AddModifyUserTicket(ClsTicketDetails ObjTicket)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_User_ID", ObjTicket.Ref_User_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Ref_Ticket_ID", ObjTicket.Ref_Ticket_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Ref_TicketType_ID", ObjTicket.Ref_TicketType_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Subject", ObjTicket.Subject, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Description", ObjTicket.Description, DbType.String);
ObJParameterCOl.Add(objDBParameter);
DBHelper objDbHelper = new DBHelper();
Int64 Ref_Ticket_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyUserTicket, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_Ticket_ID > 0)
{
ObjTicket.FileManager.ForEach(File =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@FileManagerID", File.FileManagerID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleID", Ref_Ticket_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleType", File.ModuleType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileIdentifier", File.FileIdentifier, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileName", File.FileName, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FilePath", File.FilePath, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileExtension", File.FileExtension, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileType", File.FileType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSize", File.FileSize, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSequence", File.Sequence, DbType.Int32);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar(Constant.SaveModuleFile, ObJParameterCOl1, CommandType.StoredProcedure).ToString();
});
}
if (Ref_Ticket_ID > 0 && ObjTicket.Ref_Ticket_ID == 0)
{
return("USERTICKETSUCCESS");
}
else if (Ref_Ticket_ID > 0 && ObjTicket.Ref_Ticket_ID > 0)
{
return("USERTICKETUPDATED");
}
else
{
return("TICKETALREADYEXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
public string SignUp(ClsUserDetails ObjUser)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_User_ID", ObjUser.Ref_User_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@UserCode", ObjUser.UserCode, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@FullName", ObjUser.FullName, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@EmailID", ObjUser.EmailID, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Password", ObjUser.Password, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@MobileNumber", ObjUser.MobileNumber, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Bio", ObjUser.Bio, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Gender", ObjUser.Gender, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@StudioGears", ObjUser.StudioGears, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@SocialProfileUrl", ObjUser.SocialProfileUrl, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@PayPalEmailID", ObjUser.PayPalEmailID, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@AuthorityIDs", ObjUser.AuthorityIDs, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@UserMasterDataIDs", ObjUser.UserMasterDataIDs, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@CreatedBy", ObjUser.CreatedBy, DbType.String);
ObJParameterCOl.Add(objDBParameter);
DBHelper objDbHelper = new DBHelper();
Int64 Ref_User_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.SignUp, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_User_ID > 0)
{
ObjUser.FileManager.ForEach(File =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@FileManagerID", File.FileManagerID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleID", Ref_User_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleType", File.ModuleType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileIdentifier", File.FileIdentifier, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileName", File.FileName, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FilePath", File.FilePath, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileExtension", File.FileExtension, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileType", File.FileType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSize", File.FileSize, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSequence", File.Sequence, DbType.Int32);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar(Constant.SaveModuleFile, ObJParameterCOl1, CommandType.StoredProcedure).ToString();
});
}
if (Ref_User_ID > 0 && ObjUser.Ref_User_ID == 0)
{
return("USERADDEDSUCCESS");
}
else if (Ref_User_ID > 0 && ObjUser.Ref_User_ID > 0)
{
return("USERUPDATEDSUCCESS");
}
else
{
return("USERALREADYEXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
//Update
public bool UpdateIGM(ItemGroupMasterModel objIGM)
{
string Query = string.Empty;
bool isUpdate = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ItemGroup", objIGM.ItemGroup));
paramCollection.Add(new DBParameter("@Alias", objIGM.Alias));
paramCollection.Add(new DBParameter("@PrimaryGroup", objIGM.PrimaryGroup, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@UnderGroup", objIGM.UnderGroup));
paramCollection.Add(new DBParameter("@StockAccount", objIGM.StockAccount));
paramCollection.Add(new DBParameter("@SalesAccount", objIGM.SalesAccount));
paramCollection.Add(new DBParameter("@PurchaseAccount", objIGM.PurchaseAccount));
paramCollection.Add(new DBParameter("@DefaultConfig", objIGM.DefaultConfig, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SeparateConfig", objIGM.SeparateConfig, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@Parameters", objIGM.Parameters));
paramCollection.Add(new DBParameter("@SpecifyBillReferencegrp", objIGM.SpecifyBillReferencegrp, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@BillReferencegrp", objIGM.BillReferencegrp));
paramCollection.Add(new DBParameter("@CrDaysforSale", objIGM.CrDaysforSale, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CrDaysforPurc", objIGM.CrDaysforPurc, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@IGM_Id", objIGM.IGM_id));
Query = "UPDATE ItemGroupMaster SET ItemGroup=@ItemGroup,Alias=@Alias,`PrimaryGroup`=@PrimaryGroup,UnderGroup=@UnderGroup,StockAccount=@StockAccount,SalesAccount=@SalesAccount," +
"PurchaseAccount=@PurchaseAccount,`DefaultConfig`=@DefaultConfig,`SeparateConfig`=@SeparateConfig,Parameters=@Parameters,ModifiedBy=@ModifiedBy," +
"SpecifyBillReferencegrp=@SpecifyBillReferencegrp,BillReferencegrp=@BillReferencegrp,CrDaysforSale=@CrDaysforSale,CrDaysforPurc=@CrDaysforPurc " +
"WHERE IGM_Id=@IGM_Id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <MasterseriesModel> lstSeries = new List <MasterseriesModel>();
foreach (MasterseriesModel objMaster in objIGM.IGMasterSeries)
{
objMaster.ParentId = objIGM.IGM_id;
if (objMaster.MasterId > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ParentId", objMaster.ParentId));
paramCollection.Add(new DBParameter("@SeriesId", objMaster.MasterId));
paramCollection.Add(new DBParameter("@MasterName", objMaster.MasterName));
paramCollection.Add(new DBParameter("@CreatedBy", ""));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
System.Data.IDataReader drmg =
_dbHelper.ExecuteDataReader("spUpdateIGMasterSeriesGroup", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
isUpdate = true;
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@AccountId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@AccountGroupId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@ItemId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@ItemGroupId", objMaster.ParentId));
paramCollection.Add(new DBParameter("@MaterialCenterId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@MaterialCenterGroupId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@CostCenterId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@CostCenterGroupId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@BillSundaryId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@SaleId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@PurcId", "0", DbType.Int32));
paramCollection.Add(new DBParameter("@MasterName", objMaster.MasterName));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", string.Empty));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertMasterSeriesGroupDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
isUpdate = true;
}
}
isUpdate = true;
}
}
catch (Exception ex)
{
isUpdate = false;
throw ex;
}
return(isUpdate);
}
//Udate Reciept Voucher
public bool UpdateIssuedVoucher(IssuedVoucherModel objIssued)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE Issued Voucher - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objIssued.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@From", objIssued.From));
paramCollection.Add(new DBParameter("@Authourity", objIssued.Authourity, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@FromNo", objIssued.fromNo));
paramCollection.Add(new DBParameter("@Party", objIssued.party));
paramCollection.Add(new DBParameter("@Narration", objIssued.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@id", objIssued.IV_Id));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "UPDATE Issued_Voucher SET [Issued_Date]=@Date,[From]=@From,[Rcvd Authourity]=@Authourity," +
"[FromNo]=@FromNo,[Party]=@Party,[Narration]=@Narration," +
"[ModifiedBy]=@ModifiedBy " +
"WHERE Issued_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <ReceviedModel> lstAcct = new List <ReceviedModel>();
//UPDATE Issued Account -CHILD TABLE UPDATES
foreach (ReceviedModel iss in objIssued.ReceviedModel)
{
if (iss.id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNo", (iss.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", iss.Dated));
paramCollection.Add(new DBParameter("@Amount", iss.Amount));
paramCollection.Add(new DBParameter("@BillNo", iss.BillNo));
paramCollection.Add(new DBParameter("@BillDate", iss.BillDate));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
//paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@ACT_ID", iss.id));
Query = "UPDATE Issued_Amount_Voucher SET [VoucherNo]=@VoucherNo," +
"[Dated]=@Dated,[Amount]=@Amount,[PurchaseBillNo]=@BillNo,[PurchaseDate]=@BillDate,[ModifiedBy]=@ModifiedBy " +
"WHERE [SNo]=@ACT_ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ID", (objIssued.IV_Id)));
paramCollection.Add(new DBParameter("@VoucherNo", (iss.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", iss.Dated));
paramCollection.Add(new DBParameter("@amount", iss.Amount));
paramCollection.Add(new DBParameter("@BillNo", iss.BillNo));
paramCollection.Add(new DBParameter("@BillDate", iss.BillDate));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Issued_Amount_Voucher ([Issued_Id],[VoucherNo],[Dated],[Amount],[PurchaseBillNo],[PurchaseDate]," +
"[CreatedBy]) VALUES " +
"(@ID,@VoucherNo,@Dated,@amount,@BillNo,@BillDate,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public bool SaveStype(SaleTypeModel objStype)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@SalesType", objStype.SalesType));
paramCollection.Add(new DBParameter("@typeSpecifyHereSingleAccount", objStype.SpecifyHereSingleAccount));
//paramCollection.Add(new DBParameter("@LedgerAccountBox", objStype.LedgerAccountBox));
paramCollection.Add(new DBParameter("@DifferentTaxRate", objStype.SpecifyhereforDifferentTaxRate, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SpecifyINVoucher", objStype.SpecifyINVoucher, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxable", objStype.Taxable, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeMultiTax", objStype.MultiTax, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeAgainstSTFrom", objStype.AgainstSTFrom, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxpaid", objStype.Taxpaid, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeExempt", objStype.Exempt, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxFree", objStype.TaxFree, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeLUMSumDealer", objStype.LUMSumDealer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeUnRegDealer", objStype.UnRegDealer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxInvoice", objStype.TaxInvoice, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@VatReturnCategory", objStype.VatReturnCategory));
paramCollection.Add(new DBParameter("@VatSaleTaxReport", objStype.VatSaleTaxReport, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@CalculateTaxonItemMRP", objStype.CalculateTaxonItemMRP, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxInclusiveItemPrice", objStype.TaxInclusiveItemPrice, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@CalculateTaxonpercentofAmount", objStype.CalculateTaxonpercentofAmount));
paramCollection.Add(new DBParameter("@AdjustTaxinSaleAccount", objStype.AdjustTaxinSaleAccount, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxAccount", objStype.TaxAccount));
paramCollection.Add(new DBParameter("@TypeLocal", objStype.TypeLocal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeCentral", objStype.TypeCentral, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeStockTransfer", objStype.TypeStockTransfer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeOther", objStype.TypeOther, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ExportNormal", objStype.ExportNormal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SaleinTransit", objStype.SaleinTransit, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ExportHighsea", objStype.ExportHighsea, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@IssueSTFrom", objStype.IssueSTFrom, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@FromIssuable", objStype.FromIssuable));
paramCollection.Add(new DBParameter("@ReceiveSTForm", objStype.ReceiveSTForm, System.Data.DbType.Boolean));
//paramCollection.Add(new DBParameter("@CreatedBy", objStype.CreatedBy)); ,pml[
Query = "INSERT INTO saletype (`SalesType`,`typeSpecifyHereSingleAccount`,`typeDifferentTaxRate`," +
"`typeSpecifyINVoucher`,`typeTaxable`,`tyypeMultiTax`,`typeAgainstSTFrom`,`typeTaxpaid`,`typeExempt`,`typeTaxFree`,`typeLUMSumDealer`," +
" `typeUnRegDealer`,`TaxInvoice`,`VatReturnCategory`,`VatSaleTaxReport`,`CalculateTaxonItemMRP`,`TaxInclusiveItemPrice`, " +
"`CalculateTaxonpercentofAmount`,`AdjustTaxinSaleAccount`,`TaxAccount`,`TypeLocal`,`TypeCentral`,`TypeStockTransfer`,`TypeOther`,`ExportNormal`," +
"`SaleinTransit`,`ExportHighsea`,`IssueSTFrom`,`FromIssuable`,`ReceiveSTForm`)" +
"VALUES(@SalesType,@typeSpecifyHereSingleAccount,@DifferentTaxRate,@SpecifyINVoucher,@typeTaxable, " +
"@tyypeMultiTax,@typeAgainstSTFrom,@typeTaxpaid,@typeExempt,@typeTaxFree,@typeLUMSumDealer,@typeUnRegDealer,@TaxInvoice,@VatReturnCategory, " +
"@VatSaleTaxReport,@CalculateTaxonItemMRP,@TaxInclusiveItemPrice,@CalculateTaxonpercentofAmount,@AdjustTaxinSaleAccount,@TaxAccount,@TypeLocal, " +
"@TypeCentral,@TypeStockTransfer,@TypeOther,@ExportNormal,@SaleinTransit,@ExportHighsea,@IssueSTFrom,@FromIssuable,@ReceiveSTForm)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//update Sale Type Master
public bool UpdateSalestype(eSunSpeedDomain.SaleTypeModel objStype)
{
string Query = string.Empty;
bool isUpdate = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@SalesType", objStype.SalesType));
paramCollection.Add(new DBParameter("@typeSpecifyHereSingleAccount", objStype.typeSpecifyHereSingleAccount, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@LedgerAccountBox", objStype.LedgerAccountBox));
paramCollection.Add(new DBParameter("@typeDifferentTaxRate", objStype.typeDifferentTaxRate, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeSpecifyINVoucher", objStype.typeSpecifyINVoucher, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxable", objStype.typeTaxable, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@tyypeMultiTax", objStype.typeMultiTax, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeAgainstSTFrom", objStype.typeAgainstSTFrom, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxpaid", objStype.typeTaxpaid, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeExempt", objStype.typeExempt, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxFree", objStype.typeTaxFree, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeLUMSumDealer", objStype.typeLUMSumDealer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeUnRegDealer", objStype.typeUnRegDealer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxInvoice", objStype.TaxInvoice, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@VatReturnCategory", objStype.VatReturnCategory));
paramCollection.Add(new DBParameter("@VatSaleTaxReport", objStype.VatSaleTaxReport, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@CalculateTaxonItemMRP", objStype.CalculateTaxonItemMRP, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxInclusiveItemPrice", objStype.TaxInclusiveItemPrice, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@CalculateTaxonpercentofAmount", objStype.CalculatedTax));
paramCollection.Add(new DBParameter("@AdjustTaxinSaleAccount", objStype.AdjustTaxinSaleAccount, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxAccount", objStype.TaxAccount));
paramCollection.Add(new DBParameter("@SkipVatorSaleTaxReport", objStype.SkipVatorSaleTaxReport, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeLocal", objStype.TypeLocal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeCentral", objStype.TypeCentral, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeStockTransfer", objStype.TypeStockTransfer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeOther", objStype.TypeOther, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ExportNormal", objStype.ExportNormal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SaleinTransit", objStype.SaleinTransit, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ExportHighsea", objStype.ExportHighsea, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SingleTaxRate", objStype.SingleTaxRate, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@MultiTaxRate", objStype.MultiTaxRate, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxinPercentage", objStype.TaxinPercentage, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@SurchargeInPercentage", objStype.SurchargeInPercentage, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@freezeTaxinSales", objStype.freezeTaxinSales, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@freezeTaxinSalesReturn", objStype.freezeTaxinSalesReturn, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@IssueSTFrom", objStype.IssueSTFrom, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@FromIssuable", objStype.FromIssuable));
paramCollection.Add(new DBParameter("@ReceiveSTForm", objStype.ReceiveSTForm, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@FormReceivable", objStype.FromReceivable));
paramCollection.Add(new DBParameter("@InvoiceHeading", objStype.InvoiceHeading));
paramCollection.Add(new DBParameter("@InvoiceDescription", objStype.InvoiceDescription));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@SalesTypeId", objStype.Sale_Id));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spUpdateSaleTypeMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
isUpdate = true;
}
catch (Exception ex)
{
isUpdate = false;
throw ex;
}
return(isUpdate);
}
//Udate Recevied Voucher
public bool UpdateReceviedVoucher(ReceviedVoucherModel objRecevied)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE Recevied TABLE - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objRecevied.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Series", objRecevied.Series));
paramCollection.Add(new DBParameter("@IssuingOffice", objRecevied.issuingoffice));
paramCollection.Add(new DBParameter("@FromNo", objRecevied.fromNo));
paramCollection.Add(new DBParameter("@Party", objRecevied.party));
paramCollection.Add(new DBParameter("@DateOfIssue", objRecevied.issuedDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@StateOfIssue", objRecevied.stateofissue));
paramCollection.Add(new DBParameter("@Narration", objRecevied.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@id", objRecevied.RV_Id));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "UPDATE Recevied_Voucher SET [Recevied_Date]=@Date,[Series]=@Series,[Issuing Office]=@IssuingOffice," +
"[FromNo]=@FromNo,[Party]=@Party,[DateOfIssue]=@DateOfIssue,[StateOfIssue]=StateOfIssue,[Narration]=@Narration," +
"[ModifiedBy]=@ModifiedBy " +
" WHERE Recevied_Id=@id";
//Query = "UPDATE Recevied_Voucher SET [Recevied_Date]=@Date,[Series]=@Series,[Issuing Office]=@IssuingOffice," +
// "[FromNo]=@FromNo,[Party]=@Party,[DateOfIssue]=@DateOfIssue,[StateOfIssue]=StateOfIssue,[Narration]=@Narration," +
// "[ModifiedBy]=@ModifiedBy " +
// "WHERE Recevied_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <ReceviedModel> lstAcct = new List <ReceviedModel>();
//UPDATE CREDIT NOTE ACCOUNT -CHILD TABLE UPDATES
foreach (ReceviedModel act in objRecevied.ReceviedModel)
{
if (act.id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNo", (act.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", act.Dated));
paramCollection.Add(new DBParameter("@amount", act.Amount));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ID", (act.id)));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "UPDATE Recevied_Amount_Voucher SET [VoucherNo]=@VoucherNo," +
"[Dated]=@Dated,[Amount]=@amount,[ModifiedBy]=@ModifiedBy " +
"WHERE [SNo]=@ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ID", (objRecevied.RV_Id)));
paramCollection.Add(new DBParameter("@VoucherNo", (act.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", act.Dated));
paramCollection.Add(new DBParameter("@amount", act.Amount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Recevied_Amount_Voucher ([Recevied_Id],[VoucherNo],[Dated],[Amount]," +
"[CreatedBy]) VALUES " +
"(@ID,@VoucherNo,@Dated,@amount,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public DataSet GetQualityDetails()
{
DBParameterCollection paramCollection = new DBParameterCollection();
return(_DBHelper.ExecuteDataSet("sp_GetRMRInformation", paramCollection, CommandType.StoredProcedure));
}
public DataSet GetMicrobiologicalAnalysisOfAerobicMicrobialCountSettlePlateTestDetails()
{
DBParameterCollection paramcollection = new DBParameterCollection();
return(_DBHelper.ExecuteDataSet("sp_Prod_GetMicrobiologicalAnalysisofAerobicMicrobialCountSettlePlateTestDetails", paramcollection, CommandType.StoredProcedure));
}
public DataSet GetAllEmployeeDetails()
{
DBParameterCollection paramCollection = new DBParameterCollection();
return(_DBHelper.ExecuteDataSet("sp_GetAllEmployeeDetails", paramCollection, CommandType.StoredProcedure));
}
//Update Payment Voucher
public bool UpdatePaymentVoucher(PaymentVoucherModel objPay)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objPay.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objPay.Pay_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Voucher_Number", objPay.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objPay.Type));
paramCollection.Add(new DBParameter("@PaymentModeId", objPay.PaymentModeId));
paramCollection.Add(new DBParameter("@PDDate", objPay.PDCDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@LongNarration", objPay.LongNarration));
paramCollection.Add(new DBParameter("@TotalCreditAmt", objPay.TotalCreditAmt, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalDebitAmt", objPay.TotalDebitAmt, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@id", objPay.Pay_Id));
Query = "UPDATE Payment_Voucher_Master SET `Series`=@Series,`PaymentModeId`=PaymentModeId,`Pay_Date`=@Date,`VoucherNo`=@Voucher_Number," +
"`Type`=@Type,`PDC_Date`=@PDDate,`LongNarration`=@LongNarration,`TotalCreditAmt`=@TotalCreditAmt,`TotalDebitAmt`=@TotalDebitAmt,`ModifiedBy`=@ModifiedBy," +
"`ModifiedDate`=@ModifiedDate " +
"WHERE Payment_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <AccountModel> lstAcct = new List <AccountModel>();
foreach (AccountModel act in objPay.PaymentAccountModel)
{
act.ParentId = objPay.Pay_Id;
if (act.AC_Id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@Debit", act.Debit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Credit", act.Credit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ACT_ID", act.AC_Id));
paramCollection.Add(new DBParameter("@ParentId", act.ParentId));
Query = "UPDATE Payment_Voucher_Details SET `DC`=@DC," +
"`Account`=@Account,`Debit`=@Debit,`LegderId`=@LegderId,`Credit`=@Credit,`Narration`=@Narration,`ModifiedBy`=@ModifiedBy,`ModifiedDate`=@ModifiedDate " +
"WHERE `AC_Id`=@ACT_ID AND Payment_Id=@ParentId";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@PaymentId", (act.ParentId)));
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@DebitAmount", act.Debit, DbType.Decimal));
paramCollection.Add(new DBParameter("@CreditAmount", act.Credit, DbType.Decimal));
paramCollection.Add(new DBParameter("@Amount", act.Amount, DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertPaymentDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
isUpdated = true;
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
/// <summary>
/// Save Account
/// </summary>
/// <param name="objAcctMaster"></param>
/// <returns>True/False</returns>
public bool SaveAccount(AccountMasterModel objAcctMaster)
{
string Query = string.Empty;
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Acc_DbName", "SunSpped"));
paramCollection.Add(new DBParameter("@ACC_NAME", objAcctMaster.AccountName));
paramCollection.Add(new DBParameter("@ACC_SHORTNAME", objAcctMaster.ShortName));
paramCollection.Add(new DBParameter("@ACC_PRINTNAME", objAcctMaster.PrintName));
paramCollection.Add(new DBParameter("@ACC_LedgerType", objAcctMaster.LedgerType));
paramCollection.Add(new DBParameter("@ACC_MultiCurr", objAcctMaster.MultiCurrency, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_Group", objAcctMaster.Group));
paramCollection.Add(new DBParameter("@ACC_OpBal", objAcctMaster.OPBal, System.Data.DbType.Int32));
paramCollection.Add(new DBParameter("@ACC_PrevYearBal", objAcctMaster.PrevYearBal));
paramCollection.Add(new DBParameter("@ACC_DrCrOpenBal", objAcctMaster.DrCrOpeningBal));
paramCollection.Add(new DBParameter("@ACC_DrCrPrevBal", objAcctMaster.DrCrOpeningBal));
paramCollection.Add(new DBParameter("@ACC_MaintainBitwise", objAcctMaster.MaintainBillwiseAccounts, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_ActivateInterestCal", objAcctMaster.ActivateInterestCal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_CreditDays", objAcctMaster.CreditDays));
paramCollection.Add(new DBParameter("@ACC_CreditLimit", objAcctMaster.CreditLimit));
paramCollection.Add(new DBParameter("@ACC_TypeofBuissness", objAcctMaster.TypeofBuissness));
paramCollection.Add(new DBParameter("@ACC_Transport", objAcctMaster.Transport));
paramCollection.Add(new DBParameter("@ACC_Station", objAcctMaster.Station));
paramCollection.Add(new DBParameter("@ACC_SpecifyDefaultSaleType", objAcctMaster.specifyDefaultSaleType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_DefaultSaleType", objAcctMaster.DefaultSaleType));
paramCollection.Add(new DBParameter("@ACC_FreezeSaleType", objAcctMaster.FreezeSaleType));
paramCollection.Add(new DBParameter("@ACC_SpecifyDefaultPurType", objAcctMaster.SpecifyDefaultPurType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_DefaultPurcType", objAcctMaster.DefaultPurcType));
paramCollection.Add(new DBParameter("@ACC_LockSalesType", objAcctMaster.LockSalesType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_LockPurcType", objAcctMaster.LockPurchaseType, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_address1", objAcctMaster.address1));
paramCollection.Add(new DBParameter("@ACC_address2", objAcctMaster.address2));
paramCollection.Add(new DBParameter("@ACC_Address3", objAcctMaster.address3));
paramCollection.Add(new DBParameter("@ACC_Address4", objAcctMaster.address4));
paramCollection.Add(new DBParameter("@ACC_State", objAcctMaster.State));
paramCollection.Add(new DBParameter("@ACC_TelephoneNumber", objAcctMaster.TelephoneNumber));
paramCollection.Add(new DBParameter("@ACC_Fax", objAcctMaster.Fax));
paramCollection.Add(new DBParameter("@ACC_MobileNumber", objAcctMaster.MobileNumber));
paramCollection.Add(new DBParameter("@ACC_email", objAcctMaster.email));
paramCollection.Add(new DBParameter("@ACC_Website", objAcctMaster.WebSite));
paramCollection.Add(new DBParameter("@ACC_enablemailquery", objAcctMaster.enablemailquery, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_enableSMSquery", objAcctMaster.enableSMSquery, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_contactperson", objAcctMaster.contactperson));
paramCollection.Add(new DBParameter("@ACC_ITPanNumber", objAcctMaster.ITPanNumber));
paramCollection.Add(new DBParameter("@ACC_LSTNumber", objAcctMaster.LstNumber));
paramCollection.Add(new DBParameter("@ACC_CSTNumber", objAcctMaster.CSTNumber));
paramCollection.Add(new DBParameter("@ACC_TIN", objAcctMaster.TIN));
paramCollection.Add(new DBParameter("@ACC_ServiceTax", objAcctMaster.ServiceTaxNumber));
paramCollection.Add(new DBParameter("@ACC_BankAccountNumber", objAcctMaster.BankAccountNumber));
paramCollection.Add(new DBParameter("@ACC_IECode", objAcctMaster.IECode));
paramCollection.Add(new DBParameter("@ACC_CreatedBy", "admin"));
paramCollection.Add(new DBParameter("@ACC_DEFAULT_CHEQUE_FORMAT", ""));
paramCollection.Add(new DBParameter("@ENABLE_CHEQUE_PRINTING", true, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ACC_Cheque_PrintName", objAcctMaster.ChequePrintName));
Query =
"INSERT INTO accountmaster (`Acc_DbName`,`ACC_NAME`,`ACC_SHORTNAME`,`ACC_PRINTNAME`,`ACC_LedgerType`,`ACC_MultiCurr`,`ACC_Group`,`ACC_OpBal`," +
"`ACC_PrevYearBal`,`ACC_DrCrOpenBal`,`ACC_DrCrPrevBal`,`ACC_MaintainBitwise`,`ACC_ActivateInterestCal`,`ACC_CreditDays`,`ACC_CreditLimit`,`ACC_TypeofBuissness`," +
"`ACC_Transport`,`ACC_Station`,`ACC_SpecifyDefaultSaleType`,`ACC_DefaultSaleType`,`ACC_FreezeSaleType`,`ACC_SpecifyDefaultPurType`,`ACC_DefaultPurcType`," +
"`ACC_LockSalesType`,`ACC_LockPurcType`,`ACC_address1`,`ACC_address2`,`ACC_Address3`,`ACC_Address4`,`ACC_State`,`ACC_TelephoneNumber,`ACC_Fax`,`ACC_MobileNumber`," +
"`ACC_email`,`ACC_Website`,`ACC_enablemailquery`,`ACC_enableSMSquery`,`ACC_contactperson`,`ACC_ITPanNumber`,`ACC_LSTNumber`,`ACC_CSTNumber`,`ACC_TIN`," +
"`ACC_ServiceTax`,`ACC_BankAccountNumber`,`ACC_IECode`,`ACC_CreatedBy`,`ACC_DEFAULT_CHEQUE_FORMAT`,`ENABLE_CHEQUE_PRINTING`,`ACC_Cheque_PrintName`)" +
"VALUES(@Acc_DbName,@ACC_NAME,@ACC_SHORTNAME,@ACC_PRINTNAME,@ACC_LedgerType,@ACC_MultiCurr,@ACC_Group,@ACC_OpBal,@ACC_PrevYearBal,@ACC_DrCrOpenBal," +
"@ACC_DrCrPrevBal,@ACC_MaintainBitwise,@ACC_ActivateInterestCal,@ACC_CreditDays,@ACC_CreditLimit,@ACC_TypeofBuissness," +
"@ACC_Transport,@ACC_Station,@ACC_SpecifyDefaultSaleType,@ACC_DefaultSaleType,@ACC_FreezeSaleType,@ACC_SpecifyDefaultPurType,@ACC_DefaultPurcType," +
"@ACC_LockSalesType,@ACC_LockPurcType,@ACC_address1,@ACC_address2,@ACC_Address3,@ACC_Address4,@ACC_State,@ACC_TelephoneNumber,@ACC_Fax,@ACC_MobileNumber," +
"@ACC_email,@ACC_Website,@ACC_enablemailquery,@ACC_enableSMSquery,@ACC_contactperson,@ACC_ITPanNumber,@ACC_LSTNumber,@ACC_CSTNumber,@ACC_TIN," +
"@ACC_ServiceTax,@ACC_BankAccountNumber,@ACC_IECode,@ACC_CreatedBy,@ACC_DEFAULT_CHEQUE_FORMAT,@ENABLE_CHEQUE_PRINTING,@ACC_Cheque_PrintName)";
return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0);
}
public DataSet GetMachineComplaintsAndRectifiedDetails()
{
DBParameterCollection paramCollection = new DBParameterCollection();
return(_DBHelper.ExecuteDataSet("prod_spGetMachineComplaintsAndRectifiedDetails", paramCollection, CommandType.StoredProcedure));
}
