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)); }