public DataTable Get_Tranc_Master_Search(string Transection_Type_Desc)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Transection_Type_Desc", Transection_Type_Desc);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Get_Tranc_Master_Search]");
return(ds.Tables[0]);
}
public DataTable Ret_Student_Create_Search_Group(string qryCond)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@qryCond", qryCond);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Ret_Student_Create_Search_Group]");
return(ds.Tables[0]);
}
public DataTable Get_Fee_Group_Master_Search(string Fees_Group_Desc)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Fees_Group_Desc", Fees_Group_Desc);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Get_Fee_Group_Master_Search]");
return(ds.Tables[0]);
}
public DataTable IsExists(int Proforma_inv_id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Proforma_inv_id", Proforma_inv_id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[ProcIsExists]");
return(ds.Tables[0]);
}
public DataTable GetChecK_Box_data(string Flag)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Flag", Flag);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam("[GetChecK_Box_data]");
return(ds.Tables[0]);
}
public DataTable IsInvoiceExists(string Stu_id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Stu_id", Stu_id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[IsInvoiceExists]");
return(ds.Tables[0]);
}
public DataTable SetDropDown(int Flag)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Flag", Flag);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "SetDropdown");
return(ds.Tables[0]);
}
public DataTable Set_Trancs_Master(string Id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Transection_Type_Id", Id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Set_Trancs_Master]");
return(ds.Tables[0]);
}
public DataTable SetFee_Group_Acedamic_Detail(string Id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Fees_Group_Det_Id", Id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[SetFee_Group_Acedamic_Detail]");
return(ds.Tables[0]);
}
public DataTable SetFeeItems(string Id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Fees_Items_Id", Id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[SetFeeItem]");
return(ds.Tables[0]);
}
public DataTable Set_Bank_Master_search(string Flag)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Flag", Flag);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Set_Bank_Master_search]");
return(ds.Tables[0]);
}
public DataTable SetFee_Period(string Id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Period_id", Id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[SetFeePeriod]");
return(ds.Tables[0]);
}
public DataTable GetFeeGroup_Acadyear_Data(string acyear_id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@acyear_id", acyear_id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[GetFeeGroup_Acadyear_Data]");
return(ds.Tables[0]);
}
public DataTable IsPeriodDescriptionExists(string Period_Desc)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Period_Desc", Period_Desc);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[IsPeriodDescriptionExists]");
return(ds.Tables[0]);
}
public DataTable GetFee_Period_Data(string Period_Desc)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Period_Desc", Period_Desc);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[GetFee_Period_Data]");
return(ds.Tables[0]);
}
public DataTable Get_Bank_Master_Search(string Bank_Name)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Bank_Name", Bank_Name);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Get_Bank_Master]");
return(ds.Tables[0]);
}
public DataTable Get_Fees_Item_Search(string Fees_Code)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Fees_Code", Fees_Code);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Get_Fees_Item_Search]");
return(ds.Tables[0]);
}
public DataTable GetFeeGroup_Detail_Data(string Fees_Pay_Type)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Fees_Pay_Type", Fees_Pay_Type);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[GetFeeGroup_Detail_Data]");
return(ds.Tables[0]);
}
public DataTable GenerateStudentProformaInvoice(int Flag, string Value)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Flag", Flag);
param[1] = new SqlParameter("@Value", Value);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[GenerateStudentProformaInvoice]");
return(ds.Tables[0]);
}
public DataTable SetExternalAndFeeGroupDetails(int Flag, int accyaerid)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Flag", Flag);
param[1] = new SqlParameter("@acyear_id", accyaerid);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[SetExternalGroupFeeGroupDetails]");
return(ds.Tables[0]);
}
public DataTable SetProformaStudentGrid(int Flag, string Value)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Flag", Flag);
param[1] = new SqlParameter("@Value", Value);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[SetProformaStudentGridView]");
return(ds.Tables[0]);
}
public DataTable SetFeeGroupDetails(int Flag, int Fees_Group_Id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Flag", Flag);
param[1] = new SqlParameter("@Fees_Group_Id", Fees_Group_Id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[SetFeeGroupGridViewDetails]");
return(ds.Tables[0]);
}
public DataTable SetFeeGroupDropdownList(int Flag, int acyearid)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Flag", Flag);
param[1] = new SqlParameter("@acyear_id", acyearid);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[SetDropDownFeeGroupDDL]");
return(ds.Tables[0]);
}
public DataTable IsStuidAndStudntGroupExists(string Stu_id, int Stu_Group_id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Stu_id", Stu_id);
param[1] = new SqlParameter("@Stu_Group_Id", Stu_Group_id);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[IsStuidAndStudntGroupExists]");
return(ds.Tables[0]);
}
public DataTable InsertUpdateAcdGroup(string id, string AcdYear, string GroupName, string Operation)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ID", id);
param[1] = new SqlParameter("@AcdYear", AcdYear);
param[2] = new SqlParameter("@GroupName", GroupName);
param[3] = new SqlParameter("@Operation", Operation);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[InsertUpdateAcdGroup]");
if (ds != null)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
public DataTable Insert_StudentGroup_Details(int Ext_Group_Id, string Stu_Id, string Stu_Name, string Stu_Class)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Ext_Group_Id", Ext_Group_Id);
param[1] = new SqlParameter("@Stu_Id", Stu_Id);
param[2] = new SqlParameter("@Stu_Name", Stu_Name);
param[3] = new SqlParameter("@Stu_Class", Stu_Class);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[Insert_StudentGroup_Details]");
if (ds != null)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
public DataTable InsertUpdateAcdYear(int id, string AcdYear, DateTime startdate, DateTime enddate, string Operation, bool IsActive)
{
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@ID", id);
param[1] = new SqlParameter("@AcdYear", AcdYear);
param[2] = new SqlParameter("@StartDate", startdate);
param[3] = new SqlParameter("@EndDate", enddate);
param[4] = new SqlParameter("@Operation", Operation);
param[5] = new SqlParameter("@IsActive", IsActive);
DataAccessLayer2 da = new DataAccessLayer2();
DataSet ds = da.getDataByParam(param, "[InsertUpdateAcdYear]");
if (ds != null)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}