public int AddUpdateDelete()
{
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.CRUDConnString);
SqlParameter[] objParam = new SqlParameter[]
{
new SqlParameter("@CategoryMasterCatKey", CategoryMasterCatKey),
new SqlParameter("@CategoryMasterCatName", CategoryMasterCatName),
new SqlParameter("@CategoryMasterCatVal", CategoryMasterCatVal),
new SqlParameter("@CategoryMasterCatIsActive", CategoryMasterCatIsActive),
new SqlParameter("@CategoryMasterHsnCode", CategoryMasterHsnCode),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@UserID", UserID),
new SqlParameter("@Action", Mode)
};
int result = objSql.ExecuteNonQuery("CategoryMasterSave", objParam);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddUpdateDelete()
{
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.CRUDConnString);
SqlParameter[] objParam = new SqlParameter[]
{
new SqlParameter("@CustomerID", CustomerID),
new SqlParameter("@CustomerName", CustomerName),
new SqlParameter("@CustomerAddress", CustomerAddress),
new SqlParameter("@CustomerStateFKey", CustomerStateFKey),
new SqlParameter("@CustomerCityFKey", CustomerCityFKey),
new SqlParameter("@CustomerAreaFKey", CustomerAreaFKey),
new SqlParameter("@CustomerContactNo", CustomerContactNo),
new SqlParameter("@CustomerEmail", CustomerEmail),
new SqlParameter("@CustomerGSTNo", CustomerGSTNo),
new SqlParameter("@CustomerCSTNo", CustomerCSTNo),
new SqlParameter("@CustomerIsActive", CustomerIsActive),
new SqlParameter("@CustomerGSTDate", CustomerGSTDate),
new SqlParameter("@CustomerCSTDate", CustomerCSTDate),
new SqlParameter("@CustomerContactPerson", CustomerContactPerson),
new SqlParameter("@CustomerPanNo", CustomerPanNo),
new SqlParameter("@UserID", UserID),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode)
};
int result = objSql.ExecuteNonQuery("CustomerMasterSave", objParam);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddUpdateDelete()
{
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.CRUDConnString);
SqlParameter[] objParam = new SqlParameter[]
{
new SqlParameter("@CompanyBusinessKey", CompanyBusinessKey),
new SqlParameter("@CompanyName", CompanyName),
new SqlParameter("@CompanyBusinessTitle", CompanyBusinessTitle),
new SqlParameter("@CompanyBusinessDescription", CompanyBusinessDescription),
new SqlParameter("@CompanyBusinessAddress", CompanyBusinessAddress),
new SqlParameter("@CompanyBusinessContact1", CompanyBusinessContact1),
new SqlParameter("@CompanyBusinessContact2", CompanyBusinessContact2),
new SqlParameter("@CompanyBusinessGstTinNo", CompanyBusinessGstTinNo),
new SqlParameter("@CompanyBusinessBankName", CompanyBusinessBankName),
new SqlParameter("@CompanyBusinessBankAcctNo", CompanyBusinessBankAcctNo),
new SqlParameter("@CompanyBusinessBankIFSCCode", CompanyBusinessBankIFSCCode),
new SqlParameter("@CompanyBusinessBankBranch", CompanyBusinessBankBranch),
new SqlParameter("@CompanyStateName", CompanyStateName),
new SqlParameter("@CompanyStateCode", CompanyStateCode),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode),
};
int result = objSql.ExecuteNonQuery("CompanyBusinessSave", objParam);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddUpdateDelete()
{
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.CRUDConnString);
SqlParameter[] objParam = new SqlParameter[]
{
new SqlParameter("@UserID", UserID),
new SqlParameter("@UserFirstName", UserFirstName),
new SqlParameter("@UserLastName", UserLastName),
new SqlParameter("@UserName", UserName),
new SqlParameter("@UserPassword", UserPassword),
new SqlParameter("@UserEmail", UserEmail),
new SqlParameter("@UserAddress", UserAddress),
new SqlParameter("@UserStateFKey", UserStateFKey),
new SqlParameter("@UserCityFKey", UserCityFKey),
new SqlParameter("@UserAreaFKey", UserAreaFKey),
new SqlParameter("@UserPhone", UserPhone),
new SqlParameter("@UserRollFKey", UserRollFKey),
new SqlParameter("@UserIsActive", UserIsActive),
new SqlParameter("@Action", Mode),
new SqlParameter("@CompanyID", CompanyID),
};
int result = objSql.ExecuteNonQuery("UserMasterSave", objParam);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddUpdateDelete()
{
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.CRUDConnString);
SqlParameter[] objParam = new SqlParameter[]
{
new SqlParameter("@JobMasterKey", JobMasterKey),
new SqlParameter("@JobMasterDate", JobMasterDate),
new SqlParameter("@JobMasterJobPersionFKey", JobMasterJobPersionFKey),
new SqlParameter("@JobMasterBillBookNo", JobMasterBillBookNo),
new SqlParameter("@JobMasterInvoiceNo", JobMasterInvoiceNo),
new SqlParameter("@JobMasterInvoiceDate", JobMasterInvoiceDate),
new SqlParameter("@JobMasterChlnNo", JobMasterChlnNo),
new SqlParameter("@JobMasterChlnDate", JobMasterChlnDate),
new SqlParameter("@JobMasterGrossTotal", JobMasterGrossTotal),
new SqlParameter("@JobMasterCartage", JobMasterCartage),
new SqlParameter("@JobMasterSubTotal", JobMasterSubTotal),
new SqlParameter("@JobMasterVatPerc", JobMasterVatPerc),
new SqlParameter("@JobMasterVatAmount", JobMasterVatAmount),
new SqlParameter("@JobTransactionXML", JobTransactionXML),
new SqlParameter("@JobMasterMainTotal", JobMasterMainTotal),
new SqlParameter("@JobMasterJobPersionDetail", JobMasterJobPersionDetail),
new SqlParameter("@JobMasterAddTaxPer", JobMasterAddTaxPer),
new SqlParameter("@JobMasterAddTaxAmt", JobMasterAddTaxAmt),
new SqlParameter("@JobMasterDiscPer", JobMasterDiscPer),
new SqlParameter("@JobMasterDiscAmount", JobMasterDiscAmount),
new SqlParameter("@JobMasterItemAmt", JobMasterItemAmt),
new SqlParameter("@JobMasterType", JobMasterType),
new SqlParameter("@JobMasterDiscountCalculate", JobMasterDiscountCalculate),
new SqlParameter("@JobMasterPaymentXML", JobMasterPaymentXML),
new SqlParameter("@JobMasterPaidAmount", JobMasterPaidAmount),
new SqlParameter("@JobMasterPendingAmount", JobMasterPendingAmount),
new SqlParameter("@JobMasterPoNo", JobMasterPoNo),
new SqlParameter("@TranMasterTransportDetail", TranMasterTransportDetail),
new SqlParameter("@JobMasterISGTPer", JobMasterISGTPer),
new SqlParameter("@JobMasterISGTAmount", JobMasterISGTAmount),
new SqlParameter("@JobMasterReverseCharge", JobMasterReverseCharge),
new SqlParameter("@JobMasterVehicleNo", JobMasterVehicleNo),
new SqlParameter("@UserID", UserID),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode)
};
int result = objSql.ExecuteNonQuery("JobMasterSave", objParam);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddUpdateDelete()
{
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.CRUDConnString);
SqlParameter[] objParam = new SqlParameter[]
{
new SqlParameter("@ManufacturerMasterKey", ManufacturerMasterKey),
new SqlParameter("@ManufacturerMasterDate", ManufacturerMasterDate),
new SqlParameter("@ManufacturerMasterPurchaseKey", ManufacturerMasterPurchaseKey),
new SqlParameter("@ManufacturerMasterXML", ManufacturerMasterXML),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode),
new SqlParameter("@UserID", UserID)
};
int result = objSql.ExecuteNonQuery("ManufacturerMasterSave", objParam);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}