public int DeleteAddressCategory(string CompanyId, string strAddressCategoryID, string strIsActive, string strModifiedBy, string strModifiedDate)
{
PassDataToSql[] paramList = new PassDataToSql[6];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Address_Category_ID", strAddressCategoryID, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@IsActive", strIsActive, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@ModifiedBy", strModifiedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@ModifiedDate", strModifiedDate, PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Set_AddressCategory_RowStatus", paramList);
return(Convert.ToInt32(paramList[5].ParaValue));
}
public DataTable GetDistinctAddressName(string CompanyId, string prefixlength)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[4];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@AddressCategoryId", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@AddressName", prefixlength, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@optype", "6", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Set_AddressCategory_SelectRow", paramList);
return(dtInfo);
}
public DataTable GetLeaveMasterByLeaveName(string CompanyId, string strLeaveName)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[4];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Leave_Id", "0", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Leave_Name", strLeaveName, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@optype", "5", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Att_LeaveMaster_SelectRow", paramList);
return(dtInfo);
}
public int DeleteEmployeeHolidayMasterByEmpIdandDate(string CompanyId, string HolidayId, string EmpId, string HolidayDate)
{
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Holiday_Id", HolidayId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Emp_Id", EmpId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Holiday_Date", HolidayDate, PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Set_Employee_Holiday_Delete_EmpId", paramList);
return(Convert.ToInt32(paramList[4].ParaValue));
}
public DataTable GetProductByCategoryId(string CompanyId, string CategoryId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[4];
paramList[0] = new PassDataToSql("@CompanyId", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@ProductId", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@CategoryId", CategoryId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Optype", "2", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Inv_Product_Category_SelectRow", paramList);
return(dtInfo);
}
public int DeleteProductLedger(string CompanyId, string BrnadId, string LocationId, string TransType, string TransTypeId, string ProductId)
{//It Will Delete Paramently and stock will detect also in Stock Detail
PassDataToSql[] paramList = new PassDataToSql[7];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Brand_Id", BrnadId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Location_Id", LocationId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@TransTypeId", TransTypeId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@TransType", TransType, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@ProductId", ProductId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[6] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Inv_ProductLedger_Delete", paramList);
return(Convert.ToInt32(paramList[6].ParaValue));
}
public DataTable GetAllRecord_Emp_Due_paymentByEmpId(string Empid)
{
DataTable Dt = new DataTable();
PassDataToSql[] param = new PassDataToSql[5];
param[0] = new PassDataToSql("@Trans_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
param[1] = new PassDataToSql("@Emp_Id", Empid, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
param[2] = new PassDataToSql("@Month", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
param[3] = new PassDataToSql("@year", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
param[4] = new PassDataToSql("@Type", "3", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
Dt = da.Reuturn_Datatable_Search("sp_Pay_Employee_Due_Payment_Temp_Select_Row", param);
return(Dt);
}
public DataTable GetCountryMasterByCountryName(string strCountryName)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[3];
paramList[0] = new PassDataToSql("@Country_Name", strCountryName, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@optype", "4", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Country_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Sys_CountryMaster_SelectRow", paramList);
return(dtInfo);
}
public DataTable GetPartialLeaveRequestByEmpIdAndCurrentMonthYear(string CompanyId, string EmpId, string month, string year)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[4];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Emp_Id", EmpId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Month", month, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@year", year, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Att_PartialLeave_Request_SelectOfCurrentMonth", paramList);
return(dtInfo);
}
public DataTable GetSheduleDescription()
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[3];
paramList[0] = new PassDataToSql("@Emp_Id", "0", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Att_Date", "1/1/2000", PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@optype", "1", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Att_ScheduleDescription_SelectRow", paramList);
return(dtInfo);
}
public DataTable Get_FileTransaction_By_Documentid(string CompanyId, string TransactionId, string Documentid)
{
DataTable dt = new DataTable();
PassDataToSql[] paramlist = new PassDataToSql[4];
paramlist[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramlist[1] = new PassDataToSql("@Trans_id", TransactionId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramlist[2] = new PassDataToSql("@Document_id", Documentid, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramlist[3] = new PassDataToSql("@Optype", "5", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dt = da.Reuturn_Datatable_Search("Sp_Arc_File_Transaction_SelectRow", paramlist);
return(dt);
}
// Get all Record by status
public DataTable GetRecordBystatus(string status)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Task_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Project_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Employee_id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Status", status, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@optype", "4", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Prj_Project_Task_Select_Row", paramList);
return(dtInfo);
}
public DataTable GetGroupMasterByParentId(string strCompanyId, string strParentId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Company_Id", strCompanyId, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Group_Id", "", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Group_Name", "", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Parent_Id", strParentId, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@optype", "7", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Ems_GroupMaster_SelectRow", paramList);
return(dtInfo);
}
public DataTable GetStockDetail(string CompanyId, string ProductId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Brand_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Location_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@ProductId", ProductId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@Optype", "2", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Inv_StockDetail_SelectRow", paramList);
return(dtInfo);
}
public DataTable GetPurchaseOrderHeader(string CompanyId, string BrandId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Brand_Id", BrandId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Location_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@TransId", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@optype", "2", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Inv_PurchaseOrderHeader_SelectRow", paramList);
return(dtInfo);
}
public DataTable GetPayEmpMonth(string strEmp_Id)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Emp_Id", strEmp_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Trans_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Month", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Year", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@optype", "1", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = da.Reuturn_Datatable_Search("sp_Pay_Employe_Month_Temp_Select_Row", paramList);
return(dtInfo);
}
public int InsertPurchaseOderHeader(string CompanyId, string brandId, string Locationid, string PoNO, string PaymentModeID, string PODate, string ReferenceVoucherType, string ReferenceID, string DeliveryDate, string OrderType, string SupplierId, string CurrencyID, string CurrencyRate, string Remark, string ShippingLine, string ShipBy, string ShipmentType, string Freight_Status, string ShipUnit, string TotalWeight, string UnitRate, string DateShipping, string DateReceiving, string PartialShipment, string Condition_1, string Condition_2, string Condition_3, string Condition_4, string Condition_5, string Field1, string Field2, string Field3, string Field4, string Field5, string Field6, string Field7, string IsActive, string CreatedBy, string CreatedDate, string ModifiedBy, string ModifiedDate)
{
PassDataToSql[] paramList = new PassDataToSql[42];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Brand_Id", brandId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Location_Id", Locationid, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@PoNO", PoNO, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@PaymentModeID", PaymentModeID, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@PODate", PODate, PassDataToSql.ParaTypeList.DateTime, PassDataToSql.ParaDirectonList.Input);
paramList[6] = new PassDataToSql("@ReferenceVoucherType", ReferenceVoucherType, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[7] = new PassDataToSql("@ReferenceID", ReferenceID, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[8] = new PassDataToSql("@OrderType", OrderType, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[9] = new PassDataToSql("@DeliveryDate", DeliveryDate, PassDataToSql.ParaTypeList.DateTime, PassDataToSql.ParaDirectonList.Input);
paramList[10] = new PassDataToSql("@SupplierId", SupplierId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[11] = new PassDataToSql("@CurrencyID", CurrencyID, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[12] = new PassDataToSql("@CurrencyRate", CurrencyRate, PassDataToSql.ParaTypeList.Float, PassDataToSql.ParaDirectonList.Input);
paramList[13] = new PassDataToSql("@Remark", Remark, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[14] = new PassDataToSql("@ShippingLine", ShippingLine, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[15] = new PassDataToSql("@ShipBy", ShipBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[16] = new PassDataToSql("@ShipmentType", ShipmentType, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[17] = new PassDataToSql("@Freight_Status", Freight_Status, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[18] = new PassDataToSql("@ShipUnit", ShipUnit, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[19] = new PassDataToSql("@TotalWeight", TotalWeight, PassDataToSql.ParaTypeList.Float, PassDataToSql.ParaDirectonList.Input);
paramList[20] = new PassDataToSql("@UnitRate", UnitRate, PassDataToSql.ParaTypeList.Float, PassDataToSql.ParaDirectonList.Input);
paramList[21] = new PassDataToSql("@DateShipping", DateShipping, PassDataToSql.ParaTypeList.DateTime, PassDataToSql.ParaDirectonList.Input);
paramList[22] = new PassDataToSql("@DateReceiving", DateReceiving, PassDataToSql.ParaTypeList.DateTime, PassDataToSql.ParaDirectonList.Input);
paramList[23] = new PassDataToSql("@PartialShipment", PartialShipment, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[24] = new PassDataToSql("@Condition_1", Condition_1, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[25] = new PassDataToSql("@Condition_2", Condition_2, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[26] = new PassDataToSql("@Condition_3", Condition_3, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[27] = new PassDataToSql("@Condition_4", Condition_4, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[28] = new PassDataToSql("@Condition_5", Condition_5, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[29] = new PassDataToSql("@Field1", Field1, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[30] = new PassDataToSql("@Field2", Field2, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[31] = new PassDataToSql("@Field3", Field3, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[32] = new PassDataToSql("@Field4", Field4, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[33] = new PassDataToSql("@Field5", Field5, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[34] = new PassDataToSql("@Field6", Field6, PassDataToSql.ParaTypeList.Bit, PassDataToSql.ParaDirectonList.Input);
paramList[35] = new PassDataToSql("@Field7", Field7, PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[36] = new PassDataToSql("@IsActive", IsActive, PassDataToSql.ParaTypeList.Bit, PassDataToSql.ParaDirectonList.Input);
paramList[37] = new PassDataToSql("@CreatedBy", CreatedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[38] = new PassDataToSql("@CreatedDate", CreatedDate, PassDataToSql.ParaTypeList.DateTime, PassDataToSql.ParaDirectonList.Input);
paramList[39] = new PassDataToSql("@ModifiedBy", ModifiedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[40] = new PassDataToSql("@ModifiedDate", ModifiedDate, PassDataToSql.ParaTypeList.DateTime, PassDataToSql.ParaDirectonList.Input);
paramList[41] = new PassDataToSql("@RerID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Inv_PurchaseOrderHeader_Insert", paramList);
return(Convert.ToInt32(paramList[41].ParaValue));
}
public DataTable getDirectoryMaster(string CompanyId, string Directoryid)
{
DataTable dt = new DataTable();
PassDataToSql[] paramlist = new PassDataToSql[4];
paramlist[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramlist[1] = new PassDataToSql("@id", Directoryid, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramlist[2] = new PassDataToSql("@Directory_Name", "", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramlist[3] = new PassDataToSql("@Optype", "2", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dt = da.Reuturn_Datatable_Search("Sp_Arc_Directory_Creation_SelectRow", paramlist);
return(dt);
}
public DataTable GetEmployeeParameter(string CompanyId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[3];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Emp_Id", "", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@optype", "2", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Set_Employee_Parameter_SelectRow", paramList);
return(dtInfo);
}
public int DeleteDirectoryMaster(string CompanyId, string DirectoryId, string IsActive, string ModifiedBy, string ModifiedDate)
{
PassDataToSql[] param = new PassDataToSql[6];
param[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
param[1] = new PassDataToSql("@id", DirectoryId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
param[2] = new PassDataToSql("@IsActive", IsActive, PassDataToSql.ParaTypeList.Bit, PassDataToSql.ParaDirectonList.Input);
param[3] = new PassDataToSql("@ModifiedBy", ModifiedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
param[4] = new PassDataToSql("@ModifiedDate", ModifiedDate, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
param[5] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
da.execute_Sp("Sp_Arc_Directory_Creation_RowStatus", param);
return(Convert.ToInt32(param[5].ParaValue));
}
public DataTable GetDocumentNumberAll(string strCompanyId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Trans_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Company_Id", strCompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Object_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@optype", "1", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@Module_Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dtInfo = Daclass.Reuturn_Datatable_Search("sp_Set_DocNumber_SelectRow", paramList);
return(dtInfo);
}
public DataTable GetPayDeducPostedAll(string strEmp_Id)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[4];
paramList[0] = new PassDataToSql("@Emp_Id", strEmp_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Month", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Year", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@optype", "2", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
daClass = new DataAccessClass();
dtInfo = daClass.Reuturn_Datatable_Search("sp_Pay_Employe_Deduction_Select_Row", paramList);
return(dtInfo);
}
public int UpdateRecord_Pay_Employee_Penalty_claim(string strEmployeeId, string strEmpPenalty, string strTotalClaim)
{
PassDataToSql[] param = new PassDataToSql[4];
param[0] = new PassDataToSql("@Emp_Id", strEmployeeId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
param[1] = new PassDataToSql("@Employee_Penalty", strEmpPenalty, PassDataToSql.ParaTypeList.Float, PassDataToSql.ParaDirectonList.Input);
param[2] = new PassDataToSql("@Employee_Claim", strTotalClaim, PassDataToSql.ParaTypeList.Float, PassDataToSql.ParaDirectonList.Input);
param[3] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
//param[0] = new PassDataToSql("@Company_id",CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
//param[0] = new PassDataToSql("@Company_id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
da.execute_Sp("sp_Pay_Employe_Month_Temp_Update_penalty_claim", param);
return(Convert.ToInt32(param[3].ParaValue));
}
public int UpdateContactGroup(string strCompany_Id, string strContact_Id, string strGroup_Id, string strIsActive, string strModifiedBy, string strModifiedDate)
{
PassDataToSql[] paramList = new PassDataToSql[7];
paramList[0] = new PassDataToSql("@Company_Id", strCompany_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Contact_Id", strContact_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Group_Id", strGroup_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@IsActive", strIsActive, PassDataToSql.ParaTypeList.Bit, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@ModifiedBy", strModifiedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@ModifiedDate", strModifiedDate, PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[6] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Ems_Contact_Group_Update", paramList);
return(Convert.ToInt32(paramList[17].ParaValue));
}
public DataTable GetTransferDetailbyTransferId(string CompanyId, string BrandId, string LocationId, string TransferId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[5];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Brand_Id", BrandId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@FromLocationId", LocationId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Transfer_Id", TransferId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@optype", "2", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Inv_TransferDetail_SelectRow", paramList);
return(dtInfo);
}
public int DeleteQuotationHeader(string strCompany_Id, string strBrand_Id, string strLocation_Id, string strSQuotation_Id, string IsActive, string ModifiedBy, string ModifiedDate)
{
PassDataToSql[] paramList = new PassDataToSql[8];
paramList[0] = new PassDataToSql("@Company_Id", strCompany_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Brand_Id", strBrand_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Location_Id", strLocation_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@SQuotation_Id", strSQuotation_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@IsActive", IsActive, PassDataToSql.ParaTypeList.Bit, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@ModifiedBy", ModifiedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[6] = new PassDataToSql("@ModifiedDate", ModifiedDate, PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[7] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Inv_SalesQuotationHeader_RowStatus", paramList);
return(Convert.ToInt32(paramList[7].ParaValue));
}
public DataTable GetDeviceParameterByCompanyId(string ParamName, string CompanyId)
{
DataTable dtInfo = new DataTable();
PassDataToSql[] paramList = new PassDataToSql[4];
paramList[0] = new PassDataToSql("@Id", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Param_Name", "", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@optype", "2", PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
dtInfo = daClass.Reuturn_Datatable_Search("sp_Att_Device_Parameter_SelectRow", paramList);
return(dtInfo);
}
public int DeleteStockDetail(string CompanyId, string BrnadId, string LocationId, string ProductId, string strIsActive, string strModifiedBy, string strModifiedDate)
{
PassDataToSql[] paramList = new PassDataToSql[8];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Brand_Id", BrnadId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Location_Id", LocationId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@ProductId", ProductId, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@IsActive", strIsActive, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@ModifiedBy", strModifiedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[6] = new PassDataToSql("@ModfiedDate", strModifiedDate, PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[7] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Inv_StockDetail_RowStatus", paramList);
return(Convert.ToInt32(paramList[7].ParaValue));
}
public int DeletePurchaseRequestHeader(string CompanyId, string brand_ID, string Location_Id, string Trans_Id, string IsActive, string ModifiedBy, string ModifiedDate)
{
PassDataToSql[] paramList = new PassDataToSql[8];
paramList[0] = new PassDataToSql("@Company_Id", CompanyId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@brand_ID", brand_ID, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Location_Id", Location_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Trans_Id", Trans_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@IsActive", IsActive, PassDataToSql.ParaTypeList.Bit, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@ModifiedBy", ModifiedBy, PassDataToSql.ParaTypeList.Nvarchar, PassDataToSql.ParaDirectonList.Input);
paramList[6] = new PassDataToSql("@ModifiedDate", ModifiedDate, PassDataToSql.ParaTypeList.Date, PassDataToSql.ParaDirectonList.Input);
paramList[7] = new PassDataToSql("@ReferanceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Inv_PurchaseRequestHeader_RowStatus", paramList);
return(Convert.ToInt32(paramList[7].ParaValue));
}
public int InsertPayrollEmpDeduction(string strEmp_Id, string strMonth, string strYear, string strRef_Id, string strDeductionId, string strDeductionType, string strAllowancValue, string strActDeductionValue)
{
PassDataToSql[] paramList = new PassDataToSql[9];
paramList[0] = new PassDataToSql("@Emp_Id", strEmp_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[1] = new PassDataToSql("@Month", strMonth, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[2] = new PassDataToSql("@Year", strYear, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[3] = new PassDataToSql("@Ref_Id", strRef_Id, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[4] = new PassDataToSql("@Deduction_Id", strDeductionId, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[5] = new PassDataToSql("@Deduction_Type", strDeductionType, PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Input);
paramList[6] = new PassDataToSql("@Deduction_Value", strAllowancValue, PassDataToSql.ParaTypeList.Float, PassDataToSql.ParaDirectonList.Input);
paramList[7] = new PassDataToSql("@Act_Deduction_Value", strActDeductionValue, PassDataToSql.ParaTypeList.Float, PassDataToSql.ParaDirectonList.Input);
paramList[8] = new PassDataToSql("@ReferenceID", "0", PassDataToSql.ParaTypeList.Int, PassDataToSql.ParaDirectonList.Output);
daClass.execute_Sp("sp_Pay_Employe_Deduction_Temp_Insert", paramList);
return(Convert.ToInt32(paramList[8].ParaValue));
}
