public static int SaveFeesHead(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
oDm.Add("@feesID", SqlDbType.Int, stremGroup.feesID);
oDm.Add("@fees", SqlDbType.NVarChar, 200, stremGroup.Fees);
oDm.Add("@FeesHeadType", SqlDbType.VarChar, 10, stremGroup.FeesHeadType);
oDm.Add("@AssestLedgerID_FK", SqlDbType.Int, stremGroup.AssestLedgerID_FK);
oDm.Add("@IncomeLedgerID_FK", SqlDbType.Int, stremGroup.IncomeLedgerID_FK);
oDm.Add("@IsRefundable", SqlDbType.Bit, stremGroup.IsRefundable);
oDm.Add("@IsOneTimeApplicable", SqlDbType.Bit, stremGroup.IsOneTimeApplicable);
oDm.Add("@IsYearlyFees", SqlDbType.Bit, stremGroup.IsYearlyFees);
oDm.Add("@IsMonthlyFees", SqlDbType.Bit, stremGroup.IsMonthlyFees);
oDm.Add("@IsTaxHead", SqlDbType.Bit, stremGroup.IsTaxHead);
if (stremGroup.IsTaxHead == true)
{
oDm.Add("@TaxDependencyHead", SqlDbType.Int, stremGroup.TAXDependencyHead);
}
else
{
oDm.Add("@TaxDependencyHead", SqlDbType.Int, DBNull.Value);
}
return(oDm.ExecuteNonQuery("usp_fees_insert"));
}
}
public static DataTable AllFees(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
if (stremGroup.courseID == 0)
{
oDm.Add("@courseID", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@courseID", SqlDbType.Int, stremGroup.courseID);
}
if (stremGroup.intCompanyId == 0)
{
oDm.Add("@int_company_id", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@int_company_id", SqlDbType.Int, stremGroup.intCompanyId);
}
return(oDm.ExecuteDataTable("usp_fees_insert"));
}
}
private void populatefees()
{
//--------------------------------------------------------
panelfeesDetails1.Controls.Add(new LiteralControl("<table style='width:60%;border-collapse:collapse;' rules='all'>"));
panelfeesDetails1.Controls.Add(new LiteralControl("<tr class='HeaderStyle'>"));
panelfeesDetails1.Controls.Add(new LiteralControl("<th scope='col'>"));
panelfeesDetails1.Controls.Add(new LiteralControl(" Fees"));
panelfeesDetails1.Controls.Add(new LiteralControl("</th>"));
//if (courseType == 1 || courseType == 3)
//{
// headerCount = 4;
// width = 80;
//}
//else
//{
// headerCount = 8;
// width = 50;
//}
headerCount = 1;
width = 50;
////////CREATE HEADER .////////////////////////////
createHeader(headerCount, width);
panelfeesDetails1.Controls.Add(new LiteralControl("</tr>"));
////////END HEADER .////////////////////////////
int intItemCount = 0;
string strFeesName = "";
BusinessLayer.Accounts.StreamGroup stremGrp = new BusinessLayer.Accounts.StreamGroup();
Entity.Accounts.StreamGroup estremGrp = new Entity.Accounts.StreamGroup();
//estremGrp.co = courseType;
estremGrp.intMode = 1;
estremGrp.feesHeaderID = (ddlMembershipCategory.SelectedIndex == 0) ? 0 : Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
//estremGrp.stream_type_i
dt = new DataTable();
dt = stremGrp.GetFeesHead(estremGrp);
if (dt.Rows.Count > 0)
{
intItemCount = dt.Rows.Count;
for (int i = 0; i < intItemCount; i++)
{
strFeesName = dt.Rows[i]["fees"].ToString();
int item = Convert.ToInt32(dt.Rows[i]["id"].ToString());
panelfeesDetails1.Controls.Add(new LiteralControl("<tr class='RowStyle'>"));
createBody(headerCount, width, item, strFeesName, dt, i);
panelfeesDetails1.Controls.Add(new LiteralControl("</tr>"));
}
}
panelfeesDetails1.Controls.Add(new LiteralControl("</table>"));
;
}
public static DataTable FeesBasedOnID(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
oDm.Add("@feesID", SqlDbType.Int, stremGroup.feesID);
return(oDm.ExecuteDataTable("usp_fees_insert"));
}
}
public static DataTable GetParentStream(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
// oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
//oDm.Add("@int_company_id", SqlDbType.Int, stremGroup.intCompanyId);
// oDm.Add("@stream_type", SqlDbType.Int, stremGroup.stream_type);
return(oDm.ExecuteDataTable("usp_fees_insert"));
}
}
public static DataSet GetLoad(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
oDm.Add("@int_company_id", SqlDbType.Int, stremGroup.intCompanyId);
oDm.Add("@CourseId", SqlDbType.Int, stremGroup.courseID);
DataSet ds = new DataSet();
return(oDm.GetDataSet("usp_fees_insert", ref ds, "table"));
}
}
public static int SaveBatch(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
oDm.Add("@batchName", SqlDbType.NVarChar, stremGroup.strBatchName);
oDm.Add("@startDate", SqlDbType.NVarChar, stremGroup.strStartDate);
oDm.Add("@endDate", SqlDbType.NVarChar, stremGroup.strEndDate);
return(oDm.ExecuteNonQuery("usp_fees_insert"));
}
}
public static int SaveHeader(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
oDm.Add("@stream_type", SqlDbType.Int, stremGroup.stream_type_id);
oDm.Add("@batchID", SqlDbType.Int, stremGroup.batch_ID);
oDm.Add("@courseID", SqlDbType.Int, stremGroup.courseID);
oDm.Add("@fees_name", SqlDbType.NVarChar, stremGroup.FeesName);
oDm.Add("@feesID", SqlDbType.Int, stremGroup.feesID);
oDm.Add("@headerId", SqlDbType.Int, ParameterDirection.InputOutput, 0);
oDm.ExecuteNonQuery("usp_fees_insert");
return((int)oDm["@headerId"].Value);
}
}
public static int SaveDetails(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
oDm.Add("@feesID", SqlDbType.Int, stremGroup.feesID);
oDm.Add("@feesHeaderID", SqlDbType.Int, stremGroup.feesHeaderID);
oDm.Add("@columnName", SqlDbType.NVarChar, stremGroup.column_name);
oDm.Add("@columnValue", SqlDbType.Money, stremGroup.column_value);
return(oDm.ExecuteNonQuery("usp_fees_insert"));
//oDm.CommandType=CommandType.Text;
//(int) oDm.ExecuteScalar("SELECT SCOPE_IDENTITY()");
}
}
public static DataTable GetFeesHead(Entity.Accounts.StreamGroup stremGroup)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@int_mode", SqlDbType.Int, stremGroup.intMode);
if (stremGroup.feesHeaderID == 0)
{
oDm.Add("@feesHeaderID", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@feesHeaderID", SqlDbType.Int, stremGroup.feesHeaderID);
}
oDm.Add("@fees_name", SqlDbType.NVarChar, stremGroup.FeesName);
return(oDm.ExecuteDataTable("usp_fees_insert"));
}
}
public DataTable GetParentStream(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.GetParentStream(stremGroup));
}
public DataSet GetLoad(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.GetLoad(stremGroup));
}
public int SaveBatch(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.SaveBatch(stremGroup));
}
public int SaveDetails(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.SaveDetails(stremGroup));
}
public int SaveFeesHead(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.SaveFeesHead(stremGroup));
}
public DataTable AllFees(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.AllFees(stremGroup));
}
public DataTable GetFeesHead(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.GetFeesHead(stremGroup));
}
protected void btnStramSave_Click(object sender, EventArgs e)
{
BusinessLayer.Accounts.StreamGroup stremGrp = new BusinessLayer.Accounts.StreamGroup();
Entity.Accounts.StreamGroup estremGrp = new Entity.Accounts.StreamGroup();
//courseType = Convert.ToInt32(hidCourse_id.Value.ToString());
////--------------------------------------------------------
//if (intHeaderID == 0)
//{
// estremGrp.intMode = 4;
//}
//else
//{
// estremGrp.intMode = 12;
//}
////estremGrp.stream_type_id = Convert.ToInt32(ddlStream1.SelectedValue.ToString());
////estremGrp.batch_ID = Convert.ToInt32(ddlBatch.SelectedValue.ToString());
////estremGrp.courseID = Convert.ToInt32(ddlCourse1.SelectedValue.ToString());
//estremGrp.FeesName = txtFeesName.Text.Trim();
estremGrp.feesID = intHeaderID;
//int IntLastInsertedID = stremGrp.SaveHeader(estremGrp);
////-------------------------------------------------------
//if (IntLastInsertedID > 0)
//{
// stremGrp = new BusinessLayer.Accounts.StreamGroup();
// estremGrp = new Entity.Accounts.StreamGroup();
// estremGrp.intMode = 1;
// //estremGrp.stream_type_id = Convert.ToInt32(ddlStream1.SelectedValue.ToString());
// //estremGrp.batch_ID = Convert.ToInt32(ddlBatch.SelectedValue.ToString());
// //estremGrp.courseID = Convert.ToInt32(ddlCourse1.SelectedValue.ToString());
// dt = new DataTable();
// dt = stremGrp.GetFeesHead(estremGrp);
// if (dt.Rows.Count > 0)
// {
// if (courseType == 1 || courseType == 3)
// {
// headerCount = 4;
// }
// else
// {
// headerCount = 8;
// }
int rowAffacted = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < headerCount; j++)
{
string tdId = "txtFees_" + dt.Rows[i]["id"].ToString() + "_" + j.ToString();
TextBox tx = (TextBox)panelfeesDetails1.FindControl(tdId);
if (tx.Text.Length == 0)
{
tx.Text = "0";
}
stremGrp = new BusinessLayer.Accounts.StreamGroup();
estremGrp = new Entity.Accounts.StreamGroup();
estremGrp.intMode = 5;
estremGrp.feesID = Convert.ToInt32(dt.Rows[i]["id"].ToString());
estremGrp.feesHeaderID = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
estremGrp.column_name = j + 1;
estremGrp.column_value = Convert.ToInt32(tx.Text.ToString().Trim());
rowAffacted += stremGrp.SaveDetails(estremGrp);
}
}
// }
if (rowAffacted > 0)
{
Message.IsSuccess = true;
Message.Text = "Fees Information Saved Successfully";
}
else
{
Message.IsSuccess = false;
Message.Text = "Can't Save. Duplicate Fees Information Is Not Allowed. This Fees Head Already Exists For This Batch-Course-Stream.";
}
Message.Show = true;
int aa = panelfeesDetails1.Controls.Count;
}
public DataTable FeesBasedOnID(Entity.Accounts.StreamGroup stremGroup)
{
return(DataAccess.Accounts.StreamGroup.FeesBasedOnID(stremGroup));
}
