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>")); ; }
protected void LoadFeesHead() { BusinessLayer.Accounts.StreamGroup ObjFees = new BusinessLayer.Accounts.StreamGroup(); DataTable dt = ObjFees.GetAllFeesHead(); ddlFeesHead.DataSource = dt; ddlFeesHead.DataTextField = "fees"; ddlFeesHead.DataValueField = "id"; ddlFeesHead.DataBind(); }
protected void LoadFeesHead() { BusinessLayer.Accounts.StreamGroup obj = new BusinessLayer.Accounts.StreamGroup(); DataTable DT = obj.GetAllFeesHead(); dgvFeesHead.DataSource = DT; dgvFeesHead.DataBind(); Message.Show = false; }
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; }