public static DataSet GetInputInfo(string farmerID, string productID, string seasonID)
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
string sql = "SELECT *, CAST(InputMID as Nvarchar(50)) AS 'S_InputMID' FROM tblInputInformation WHERE FarmerID = '" + farmerID + "' AND ProductID =" + productID + " AND SeasonID = " + seasonID + " SELECT *, CAST(InputMID as Nvarchar(50)) AS 'S_InputMID' FROM tblInputTransaction WHERE InputMID in (SELECT InputMID FROM tblInputInformation WHERE FarmerID = '" + farmerID + "' AND ProductID =" + productID + " AND SeasonID = " + seasonID + ")";
return(mdbh.ExecuteDataSet(sql));
}
public static DataSet GetWeedInfo(string farmerID, string productID, string seasonID)
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
string sql = "SELECT *, CAST(WeedMIID as Nvarchar(50)) AS 'S_WeedMIID' FROM tblWeedManagementInfo WHERE FarmerID = '" + farmerID + "' AND ProductID =" + productID + " AND SeasonID = " + seasonID + " SELECT *, CAST(WeedMIID as Nvarchar(50)) AS 'S_WeedMIID' FROM tblWeedManagementInfoTransaction WHERE WeedMIID in (SELECT WeedMIID FROM tblWeedManagementInfo WHERE FarmerID = '" + farmerID + "' AND ProductID =" + productID + " AND SeasonID = " + seasonID + ")";
return(mdbh.ExecuteDataSet(sql));
}
public static DataSet GetInsectInfo()
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
string sql = "SELECT *, CAST(InsectMIID as Nvarchar(50)) AS 'S_InsectMIID' FROM tblInsectsManagementInfo WHERE [Delete] = 0 SELECT *, CAST(InsectMIID as Nvarchar(50)) AS 'S_InsectMIID' FROM tblInsectsManagementInfoTransaction WHERE InsectMIID in (SELECT InsectMIID FROM tblInsectsManagementInfo WHERE [Delete] = 0)";
return(mdbh.ExecuteDataSet(sql));
}
public static DataSet GetDisease()
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
string sql = "SELECT *, CAST(DiseaseMID as Nvarchar(50)) AS 'S_DiseaseMID' FROM dbo.tblDiseaseManagementInfo WHERE [Delete] = 0 SELECT *, CAST(DiseaseMID as Nvarchar(50)) AS 'S_DiseaseMID' FROM dbo.tblDiseaseManagementInfoTransaction WHERE DiseaseMID in (SELECT DiseaseMID FROM tblDiseaseManagementInfo WHERE [Delete] = 0)";
return(mdbh.ExecuteDataSet(sql));
}
public static DataSet GetDisease(string farmerID, string productID, string seasonID)
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
string sql = "SELECT *, CAST(DiseaseMID as Nvarchar(50)) AS 'S_DiseaseMID' FROM dbo.tblDiseaseManagementInfo WHERE FarmerID = '" + farmerID + "' AND ProductID =" + productID + " AND SeasonID = " + seasonID + " AND [Delete] = 0 SELECT *, CAST(DiseaseMID as Nvarchar(50)) AS 'S_DiseaseMID' FROM dbo.tblDiseaseManagementInfoTransaction WHERE DiseaseMID in (SELECT DiseaseMID FROM tblDiseaseManagementInfo WHERE FarmerID = '" + farmerID + "' AND ProductID =" + productID + " AND SeasonID = " + seasonID + " AND [Delete] = 0)";
return(mdbh.ExecuteDataSet(sql));
}
public static DataSet GetGeneralInspectionDetails()
{
MudarSPName sp = new MudarSPName();
MudarDBHelper mdbh = MudarDBHelper.Instance;
return(mdbh.ExecuteDataSet(sp.sp_getGeneralInspectionDetails));
}
public static DataSet GetInputInfo()
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
//string sql = "select IMMaterial,IMSource,it.IMDays from tblInputInformation ii,tblInputTransaction it where ii.InputMID = it.InputMTId and ii.ProductID > 0";
string sql = "SELECT *, CAST(InputMID as Nvarchar(50)) AS 'S_InputMID' FROM tblInputInformation WHERE [delete]=0 SELECT *, CAST(InputMID as Nvarchar(50)) AS 'S_InputMID' FROM tblInputTransaction WHERE InputMID in (SELECT InputMID FROM tblInputInformation WHERE [delete]=0)";
return(mdbh.ExecuteDataSet(sql));
}
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 DataSet UnitInformation(string UnitID)
{
MudarDBHelper mdbh = MudarDBHelper.Instance;
return(mdbh.ExecuteDataSet("SELECT * FROM [dbo].[tblUnitInformation] WHERE UnitId='" + UnitID + "' AND [Delete] =0"));
}