public static bool WaterTransaction_INT_UPT_DEL(int WaterMID, string WITT_Irrigation, string WITT_Days, string WITT_Period, string WITT_Planting, string CreatedBy, string ModifiedBy, int TypeOfOperation, int WITTId)
{
bool Result = false;
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("WaterMID", SqlDbType.Int, WaterMID));
Params.Add(mdbh.AddParameter("WITT_Irrigation", SqlDbType.NVarChar, WITT_Irrigation));
Params.Add(mdbh.AddParameter("WITT_Days", SqlDbType.NVarChar, WITT_Days));
Params.Add(mdbh.AddParameter("WITT_Period", SqlDbType.NVarChar, WITT_Period));
Params.Add(mdbh.AddParameter("WITT_Planting", SqlDbType.NVarChar, WITT_Planting));
Params.Add(mdbh.AddParameter("WITTId", SqlDbType.Int, WITTId));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, Result, Param_Directions.Param_Out));
try
{
List <string> output = new List <string>();
Result = (bool)mdbh.ExecuteNonQuery(sp.sp_tblWaterInfoTransaction_INSandUPDandDEL, Params);
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
public static bool BuyerApproval(string BuyerID, string ModifiedBy, bool Approval, bool Lotsample, string BCode, decimal Discount, decimal FairTrade, decimal FairTradPremium, int valueType)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("BuyerID", SqlDbType.UniqueIdentifier, new Guid(BuyerID)));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
Params.Add(mdbh.AddParameter("Approval", SqlDbType.Bit, Approval));
Params.Add(mdbh.AddParameter("Lotsample", SqlDbType.Bit, Lotsample));
Params.Add(mdbh.AddParameter("BCode", SqlDbType.NVarChar, BCode));
Params.Add(mdbh.AddParameter("Discount", SqlDbType.Decimal, Discount));
Params.Add(mdbh.AddParameter("FairTrade", SqlDbType.Decimal, FairTrade));
Params.Add(mdbh.AddParameter("FairTradPremium", SqlDbType.Decimal, FairTradPremium));
Params.Add(mdbh.AddParameter("valueType", SqlDbType.Int, valueType));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_CheckBuyerApporval, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool BuyerTransPortDetails_INSandUPDandDEL(string BuyerID, int Transportmode, string SeaportName, string AirportName, string RoadDestination, string RailStation, string CreatedBy, string ModifiedBy, int TypeOfOperation)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("BuyerID", SqlDbType.UniqueIdentifier, new Guid(BuyerID)));
Params.Add(mdbh.AddParameter("ModeofTransport", SqlDbType.Int, Transportmode));
Params.Add(mdbh.AddParameter("SeaportName", SqlDbType.NVarChar, SeaportName));
Params.Add(mdbh.AddParameter("AirportName", SqlDbType.NVarChar, AirportName));
Params.Add(mdbh.AddParameter("RoadDestination", SqlDbType.NVarChar, RoadDestination));
Params.Add(mdbh.AddParameter("RailStation", SqlDbType.NVarChar, RailStation));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_BuyerTransportDetails_INSandUPDandDEL, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool InputTransaction_INT_UPT_DEL(int InputMID, string IM_MT_HC, string IMDays, string IMPeriod, string IMPlanting, string CreatedBy, string ModifiedBy, int TypeOfOperation, int InputMTId)
{
bool Result = false;
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("InputMID", SqlDbType.Int, InputMID));
Params.Add(mdbh.AddParameter("IM_MT_HC", SqlDbType.NVarChar, IM_MT_HC));
Params.Add(mdbh.AddParameter("IMDays", SqlDbType.NVarChar, IMDays));
Params.Add(mdbh.AddParameter("IMPeriod", SqlDbType.NVarChar, IMPeriod));
Params.Add(mdbh.AddParameter("IMPlanting", SqlDbType.NVarChar, IMPlanting));
Params.Add(mdbh.AddParameter("InputMTId", SqlDbType.Int, InputMTId));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, Result, Param_Directions.Param_Out));
//Params.Add(mdbh.AddParameter("rInputMTId", SqlDbType.Int, rInputMTId, Param_Directions.Param_Out));
try
{
List <string> output = new List <string>();
Result = (bool)mdbh.ExecuteNonQuery(sp.sp_tblInputTransaction_INSandUPDandDEL, Params);
//if (output.Count >= 2)
//{
// Result = Convert.ToBoolean(output[0]);
// rInputMTId = Convert.ToInt32(!string.IsNullOrEmpty(output[1]) ? output[1] : "0");
//}
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
public static DataTable GetSeasonDetailsBasedFarmerID(string FarmerID, int SeasonYear)
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("farmerid", SqlDbType.UniqueIdentifier, new Guid(FarmerID)));
Params.Add(mdbh.AddParameter("seasonYear", SqlDbType.Int, SeasonYear));
return(mdbh.ExecuteDataTable(sp.sp_GetSeasonDetailsBasedFarmerID, Params, "FarmerSeasonDetailsName"));
}
public static DataTable Get_NewProduction_Year(DateTime Date, string Year)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("Date", SqlDbType.DateTime, Date));
Params.Add(mdbh.AddParameter("year", SqlDbType.VarChar, Year));
return(mdbh.ExecuteDataTable(sp.sp_Get_NewProduction_Year, Params, "FYear"));
}
public static int Season_INT_UPT(int SeasonID, string Seasonname, DateTime StartDate, DateTime EndDate, string createdby, string modifiedby, int typeOperation, int SeasonYear)
{
int Result = 0;
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("SeasonID", SqlDbType.Int, SeasonID));
Params.Add(mdbh.AddParameter("SeasonName", SqlDbType.NVarChar, Seasonname));
Params.Add(mdbh.AddParameter("StartDate", SqlDbType.DateTime, StartDate));
Params.Add(mdbh.AddParameter("EndDate", SqlDbType.DateTime, EndDate));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, createdby));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, modifiedby));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, typeOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Int, Result, Param_Directions.Param_Out));
Params.Add(mdbh.AddParameter("SeasonYear", SqlDbType.Int, SeasonYear));
try
{
Result = (int)mdbh.ExecuteNonQuery(sp.sp_season, Params);
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
//Code to insert/Update/Delete in tblFarmerCheckPoints
public static bool FarmerCheckPoints_INSandUPDandDEL(string FarmerID, int QuestionID, int Answer, string Note, string CreatedBy, string ModifiedBy, int TypeOfOperation, int Year)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("FarmerID", SqlDbType.UniqueIdentifier, new Guid(FarmerID)));
Params.Add(mdbh.AddParameter("QuestionID", SqlDbType.Int, QuestionID));
Params.Add(mdbh.AddParameter("Answer", SqlDbType.Int, Answer));
Params.Add(mdbh.AddParameter("Note", SqlDbType.NVarChar, Note));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("Year", SqlDbType.Int, Year));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_FarmerCheckPoints_INSandUPDandDEL, Params);
return(result);
}
catch (Exception)
{
return(result);
}
}
public static bool InspectionPlan_INS(int InspectionID, int InspectionHistoryID, string EmployeeID, string FarmerID, DateTime PlanDate, DateTime VisitDate, string CreatedBy, string ModifiedBy)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("InspectionID", SqlDbType.Int, InspectionID));
Params.Add(mdbh.AddParameter("InspectionHistoryID", SqlDbType.Int, InspectionHistoryID));
Params.Add(mdbh.AddParameter("EmployeeID", SqlDbType.UniqueIdentifier, new Guid(EmployeeID)));
Params.Add(mdbh.AddParameter("FarmerID", SqlDbType.UniqueIdentifier, new Guid(FarmerID)));
Params.Add(mdbh.AddParameter("PlanDate", SqlDbType.DateTime, PlanDate));
Params.Add(mdbh.AddParameter("VisitDate", SqlDbType.DateTime, VisitDate));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_InspectionPlan_INS, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool SupplierPriceandPaymentDetails_INSandUPDandDEL(string SupplierId, bool Exworks, bool ExSuppliersPlace, bool ForDestination, string PaymentTerm, string CreatedBy, string ModifiedBy, int TypeOfOperation)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("SupplierId", SqlDbType.UniqueIdentifier, new Guid(SupplierId)));
Params.Add(mdbh.AddParameter("Exworks", SqlDbType.Bit, Exworks));
Params.Add(mdbh.AddParameter("ExSuppliersPlace", SqlDbType.Bit, ExSuppliersPlace));
Params.Add(mdbh.AddParameter("ForDestination", SqlDbType.Bit, ForDestination));
Params.Add(mdbh.AddParameter("PaymentTerm", SqlDbType.NVarChar, PaymentTerm));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_SupplierPriceandPaymentTermsDetails_INSandUPDandDEL, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool BuyerPaymentandPriceUpdateDetails(string BuyerID, bool advance100, bool Fiftyadv50againstDocs, bool HundredagainstDocs, bool NoofDaysfromInvoice, int No_of_Days_Count_fromInvoice, int TypeOfOperation, string ModifiedBy)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("BuyerID", SqlDbType.UniqueIdentifier, new Guid(BuyerID)));
Params.Add(mdbh.AddParameter("100advance", SqlDbType.Bit, advance100));
Params.Add(mdbh.AddParameter("50adv50againstDocs", SqlDbType.Bit, Fiftyadv50againstDocs));
Params.Add(mdbh.AddParameter("100againstDocs", SqlDbType.Bit, HundredagainstDocs));
Params.Add(mdbh.AddParameter("NoofDaysfromInvoice", SqlDbType.Bit, NoofDaysfromInvoice));
Params.Add(mdbh.AddParameter("No_of_Days_Count_fromInvoice", SqlDbType.Int, No_of_Days_Count_fromInvoice));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_UPD_Buyer_PaymentandPriceandTransport_Details, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static DataTable GetDetailsAllPrices(int typeofoperation, int Qty, int productID)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("typeofoperation", SqlDbType.Int, typeofoperation));
Params.Add(mdbh.AddParameter("Qty", SqlDbType.Int, Qty));
Params.Add(mdbh.AddParameter("ProductId", SqlDbType.Int, productID));
return(mdbh.ExecuteDataTable(sp.sp_sp_Get_New_PriceDetails, Params, "GetNewPrices"));
}
public static DataTable GetDetailsAllPriceswithDate(int typeofoperation, int Qty, DateTime createdDate)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("typeofoperation", SqlDbType.Int, typeofoperation));
Params.Add(mdbh.AddParameter("Qty", SqlDbType.Int, Qty));
Params.Add(mdbh.AddParameter("createdDate", SqlDbType.DateTime, createdDate));
return(mdbh.ExecuteDataTable(sp.sp_Get_Detailed_Pricedetails, Params, "GetDetailedAllPrices"));
}
public static bool MentholPercentageDetailsINS(int PerID, int Year, int ProductID, decimal Percentage, string CreatedBy, string ModifiedBy, int TypeOfOperation)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("PerID", SqlDbType.Int, PerID));
Params.Add(mdbh.AddParameter("Year", SqlDbType.Int, Year));
Params.Add(mdbh.AddParameter("ProductID", SqlDbType.Int, ProductID));
Params.Add(mdbh.AddParameter("Percentage", SqlDbType.Decimal, Percentage));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("TypeOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_MentholPerDetails_INSandUPDandDEL, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool InspectionHistory_INSandUPDandDEL(int InspectioHistoryID, int Year, string PlanName, int SeasonID, string CreatedBY, string ModifiedBy, ref int NewHistoryId)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
List <string> output = new List <string>();
Params.Add(mdbh.AddParameter("InspectioHistoryID", SqlDbType.Int, InspectioHistoryID));
Params.Add(mdbh.AddParameter("Year", SqlDbType.Int, Year));
Params.Add(mdbh.AddParameter("PlanName", SqlDbType.NVarChar, PlanName));
Params.Add(mdbh.AddParameter("SeasonID", SqlDbType.Int, SeasonID));
Params.Add(mdbh.AddParameter("CreatedBY", SqlDbType.NVarChar, CreatedBY));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
Params.Add(mdbh.AddParameter("ReturnHistoryID", SqlDbType.Int, NewHistoryId, Param_Directions.Param_Out));
try
{
mdbh.ExecuteNonQuery(sp.sp_InspectionHistory_INSandUPDandDEL, Params, ref output);
if (output.Count >= 2)
{
result = Convert.ToBoolean(output[0]);
NewHistoryId = Convert.ToInt32(output[1]);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static DataTable GetProductDetails(string startDate, string endDate, string ProductID)
{
//MudarDBHelper mdbh = MudarDBHelper.Instance;
//return mdbh.ExecuteDataTable("SELECT tpd.ProductName,tpp.FOBPrice,tph.CreateDate FROM dbo.tblProductDetails tpd LEFT JOIN tblProductPrice tpp ON tpd.ProductId = tpp.ProductId LEFT JOIN tblPriceHistory tph ON tpp.PriceHistoryId = tph.PriceHistoryId where tpd.[Delete] = 0 AND tph.CreateDate BETWEEN '1/1/2012' AND '12/31/2012 23:59:59.978'");
//return mdbh.ExecuteDataTable("SELECT convert(nvarchar(11), CreateDate,106) as 'CreateDate', [Demo Product] , [Demo Product2] , [Demo Product4] , [Demo Product5] FROM (SELECT tpd.ProductName, tph.CreateDate ,tpp.FOBPrice FROM dbo.tblProductDetails tpd LEFT JOIN tblProductPrice tpp ON tpd.ProductId = tpp.ProductId LEFT JOIN tblPriceHistory tph ON tpp.PriceHistoryId = tph.PriceHistoryId WHERE tpd.[Delete] = 0 AND tph.CreateDate BETWEEN '1/1/2012' AND '12/31/2012 23:59:59.978') up PIVOT (sum(up.FOBPrice) for up.ProductName in ( [Demo Product] , [Demo Product2] , [Demo Product4] , [Demo Product5] )) AS pvt");
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("start", SqlDbType.NVarChar, startDate));
Params.Add(mdbh.AddParameter("end", SqlDbType.NVarChar, endDate));
Params.Add(mdbh.AddParameter("productid", SqlDbType.NVarChar, ProductID));
return(mdbh.ExecuteDataTable(sp.sp_GetProduct_PriceDetails, Params, "Pricedetails"));
}
public static bool FiledRiskt_Result_INSandUPDandDEL(int FieldRiskID, string FarmerID, int FarmID, bool Result, string CreatedBy, string ModifiedBy, int TypeOfOperation)
{
bool returnResult = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("FarmerID", SqlDbType.UniqueIdentifier, new Guid(FarmerID)));
Params.Add(mdbh.AddParameter("FieldRiskID", SqlDbType.Int, FieldRiskID));
Params.Add(mdbh.AddParameter("FarmID", SqlDbType.Int, FarmID));
Params.Add(mdbh.AddParameter("Result", SqlDbType.Bit, Result));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, returnResult, Param_Directions.Param_Out));
try
{
returnResult = (bool)mdbh.ExecuteNonQuery(sp.sp_FieldRisk_Farmer_INSandUPDandDEL, Params);
return(returnResult);
}
catch (Exception)
{
return(returnResult);
}
}
public static bool UserLogin_INS_UPD_DEL(string UserId, string ULoginID, string UPassword, string CreatedBy, string ModifiedBy, int TypeOfOperation)
{
bool result = false;
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("UserID", SqlDbType.UniqueIdentifier, new Guid(UserId)));
Params.Add(mdbh.AddParameter("UserLoginID", SqlDbType.NVarChar, ULoginID));
Params.Add(mdbh.AddParameter("UserPassword", SqlDbType.NVarChar, UPassword));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, CreatedBy));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, ModifiedBy));
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_UserLogin_INSandUPDandDEL, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool Category_INT_UPT(int categoryID, string categoryname, string createdby, string modifiedby, int typeOperation)
{
bool Result = false;
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("CategoryID", SqlDbType.Int, categoryID));
Params.Add(mdbh.AddParameter("CategoryName", SqlDbType.NVarChar, categoryname));
Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, createdby));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, modifiedby));
Params.Add(mdbh.AddParameter("Delete", SqlDbType.Bit, false));
Params.Add(mdbh.AddParameter("TypeOperation", SqlDbType.Int, typeOperation));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, Result, Param_Directions.Param_Out));
try
{
Result = (bool)mdbh.ExecuteNonQuery(sp.sp_CategoryDetails_INSandUPD, Params);
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
public static DataTable GetUpdateProductPrice(int TypeOfOperation)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("TypeOfOperation", SqlDbType.Int, TypeOfOperation));
return(mdbh.ExecuteDataTable(sp.sp_GetProductCalculationData, Params, "GetProductCalculation"));
}
public static DataTable GetLotYear(DateTime Date)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("Date", SqlDbType.DateTime, Date));
return(mdbh.ExecuteDataTable(sp.sp_Get_Lotnumber_Year, Params, "FYear"));
}
public static DataTable GetProductionYear(DateTime date)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("Date", SqlDbType.SmallDateTime, date));
return(mdbh.ExecuteDataTable(sp.sp_GetProductionYear, Params, "PYear"));
}
public static DataTable GetUpdateProductPrice(string date)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("date", SqlDbType.DateTime, date));
return(mdbh.ExecuteDataTable(sp.sp_GetProductCalculationDatabyDate, Params, "GetProductCalculation"));
}
public static DataTable GetBranchDetails(string BranchID, int Output)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
if (!string.IsNullOrEmpty(BranchID))
{
Params.Add(mdbh.AddParameter("BranchID", SqlDbType.UniqueIdentifier, new Guid(BranchID)));
}
else
{
Params.Add(mdbh.AddParameter("BranchID", SqlDbType.UniqueIdentifier, Guid.NewGuid()));
}
Params.Add(mdbh.AddParameter("output", SqlDbType.Int, Output));
return(mdbh.ExecuteDataTable(sp.sp_BranchDetails, Params, "BranchParentList"));
}
public static DataTable GetAviableQtty(int ProductID)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("ProductID", SqlDbType.Int, ProductID));
return(mdbh.ExecuteDataTable(sp.SP_CheckAvailableQty, Params, "AvailQty"));
}
public static DataTable FarmDetails(string FarmerId)
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("FarmerId", SqlDbType.UniqueIdentifier, new Guid(FarmerId)));
return(mdbh.ExecuteDataTable(sp.sp_FarmDetails, Params, "FarmerDetails"));
}
public static DataTable SeasonDetails_FarmerSeasonProduct(Guid farmerId, int ProductID, int SeasonId, int seasonYear)
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("FarmerID", SqlDbType.UniqueIdentifier, farmerId));
Params.Add(mdbh.AddParameter("ProductId", SqlDbType.Int, ProductID));
Params.Add(mdbh.AddParameter("SeasonID", SqlDbType.Int, SeasonId));
Params.Add(mdbh.AddParameter("SeasonYear", SqlDbType.Int, seasonYear));
try
{
return(mdbh.ExecuteDataTable(sp.sp_SeasonDetails_FarmerSeasonProduct, Params, "FarmerSeasonProduct"));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet GetEmployeeDetails(string EmployeeID)
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("EmployeeId", SqlDbType.UniqueIdentifier, new Guid(EmployeeID.Trim())));
return(mdbh.ExecuteDataSet(sp.sp_EmployeeDetails, Params));
}
public static bool DeletetheBuyer(string BuyerID)
{
bool result = false;
MudarDBHelper mdbh = MudarDBHelper.Instance;
MudarSPName sp = new MudarSPName();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("BuyerID", SqlDbType.UniqueIdentifier, new Guid(BuyerID)));
Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.Bit, result, Param_Directions.Param_Out));
try
{
result = (bool)mdbh.ExecuteNonQuery(sp.sp_DeleteBuyer, Params);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
//oldcode
//public static string Branch_INT_UPT_DEL(string BranchID, string BranchCode, string Bname, bool sales, bool export, bool warehose, bool other, string address, string city, string taluk, string district, string state, string country, string parentBranchID, string createdby, DateTime createdDate, string modifiedby, DateTime modifiedDate, int typeOperation)
//{
// object Return = string.Empty;
// MudarSPName sp = new MudarSPName();
// MudarDBHelper mdbh = MudarDBHelper.Instance;
// List<SqlParameter> Params = new List<SqlParameter>();
// if (string.IsNullOrEmpty(BranchID))
// {
// Params.Add(mdbh.AddParameter("BranchId", SqlDbType.UniqueIdentifier, Guid.NewGuid()));
// Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.UniqueIdentifier, Guid.NewGuid(), Param_Directions.Param_Out));
// }
// else
// {
// Params.Add(mdbh.AddParameter("ReturnValue", SqlDbType.UniqueIdentifier, new Guid(BranchID), Param_Directions.Param_Out));
// Params.Add(mdbh.AddParameter("BranchId", SqlDbType.UniqueIdentifier, new Guid(BranchID)));
// }
// Params.Add(mdbh.AddParameter("BranchCode", SqlDbType.NVarChar, BranchCode));
// Params.Add(mdbh.AddParameter("Bname", SqlDbType.NVarChar, Bname));
// Params.Add(mdbh.AddParameter("Sales", SqlDbType.Bit, sales));
// Params.Add(mdbh.AddParameter("Export", SqlDbType.Bit, export));
// Params.Add(mdbh.AddParameter("WareHousing", SqlDbType.Bit, warehose));
// Params.Add(mdbh.AddParameter("Other", SqlDbType.Bit, other));
// Params.Add(mdbh.AddParameter("Address", SqlDbType.NVarChar, address));
// Params.Add(mdbh.AddParameter("City", SqlDbType.NVarChar, city));
// Params.Add(mdbh.AddParameter("Taluk", SqlDbType.NVarChar, taluk));
// Params.Add(mdbh.AddParameter("District", SqlDbType.NVarChar, district));
// Params.Add(mdbh.AddParameter("State", SqlDbType.NVarChar, state));
// Params.Add(mdbh.AddParameter("Country", SqlDbType.NVarChar, country));
// Params.Add(mdbh.AddParameter("Designation", SqlDbType.NVarChar, ""));
// Params.Add(mdbh.AddParameter("CreatedBy", SqlDbType.NVarChar, createdby));
// Params.Add(mdbh.AddParameter("CreatedDate", SqlDbType.DateTime, createdDate));
// Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, modifiedby));
// Params.Add(mdbh.AddParameter("ModifiedDate", SqlDbType.DateTime, modifiedDate));
// Params.Add(mdbh.AddParameter("Delete", SqlDbType.Bit, false));
// Params.Add(mdbh.AddParameter("TypeOperation", SqlDbType.Int, typeOperation));
// if (string.IsNullOrEmpty(parentBranchID))
// Params.Add(mdbh.AddParameter("BranchHeadCode", SqlDbType.UniqueIdentifier, Guid.NewGuid()));
// else
// Params.Add(mdbh.AddParameter("BranchHeadCode", SqlDbType.UniqueIdentifier, new Guid(parentBranchID)));
// try
// {
// Return = mdbh.ExecuteNonQuery(sp.sp_BranchDetails_INSandUPD, Params);
// }
// catch (Exception ex)
// {
// throw ex;
// }
// return Return.ToString();
//}
/// <summary>
///
/// </summary>
/// <param name="BranchID"></param>
/// <param name="BranchCode"></param>
/// <param name="modifiedby"></param>
/// <param name="modifiedDate"></param>
/// <param name="typeOperation"></param>
/// <returns></returns>
public static bool Branch_INT_UPT_DEL(string BranchID, string modifiedby, int typeOperation)
{
//bool Return = false;
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(mdbh.AddParameter("BranchId", SqlDbType.UniqueIdentifier, new Guid(BranchID)));
Params.Add(mdbh.AddParameter("ModifiedBy", SqlDbType.NVarChar, modifiedby));
try
{
mdbh.ExecuteNonQuery(sp.sp_BranchDetails_DEL, Params);
}
catch (Exception ex)
{
throw ex;
}
return(true);
}