public IEnumerable <PriviligesModel> GetPriviliges(string id) { PriviligesModel privilige = new PriviligesModel(); List <PriviligesModel> priviliges = new List <PriviligesModel>(); using (SqlCon = new SqlConnection()) { SqlCon = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ServoSMS"]); SqlCon.Open(); string sql = "select * from privileges where User_ID='" + id + "'"; SqlCommand SqlCmd1 = new SqlCommand(sql, SqlCon); SqlDataReader SqlDtr1 = SqlCmd1.ExecuteReader(); while (SqlDtr1.Read()) { privilige.User_ID = SqlDtr1.GetValue(0).ToString(); privilige.Module_ID = SqlDtr1.GetValue(1).ToString(); privilige.SubModule_ID = SqlDtr1.GetValue(2).ToString(); privilige.ViewFlag = SqlDtr1.GetValue(3).ToString(); privilige.Add_Flag = SqlDtr1.GetValue(4).ToString(); privilige.Edit_Flag = SqlDtr1.GetValue(5).ToString(); privilige.Del_Flag = SqlDtr1.GetValue(6).ToString(); priviliges.Add(privilige); privilige = new PriviligesModel(); } SqlDtr1.Close(); return(priviliges); } }
/// <summary> /// This method is used to save the data in database with the help of ProPrivilegesEntry procedure. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, System.EventArgs e) { if (DropUserID.SelectedIndex == 0) { MessageBox.Show("Please select the User Name"); return; } List <PriviligesModel> priviliges = new List <PriviligesModel>(); int Modules = 6; int a = 0; /* Coment by vikas 29.12.2012 * int[] SubModules={4,5,12,13,52,3}; * CheckBox[] ChkView={chkView1, chkView2, chkView3, chkView4, chkView5, chkView6, chkView7, chkView8, chkView9, chkView10, chkView11, chkView12, chkView13, chkView14, chkView15, chkView16, chkView17, chkView18, chkView66, chkView67, chkView68, chkView19, chkView20, chkView21, chkView22, chkView23, chkView24, chkView25, chkView26, chkView27,chkView44,chkView64,chkView69,chkView70, chkView28, chkView29, chkView30, chkView31, chkView32, chkView33, chkView34, chkView35, chkView36, chkView37, chkView38, chkView39,chkView40,chkView41,chkView42,chkView43,chkView45,chkView46,chkView47,chkView48,chkView49,chkView50,chkView54,chkView55,chkView56,chkView57,chkView58,chkView59,chkView60,chkView61,chkView62,chkView63,chkView65,chkView71,chkView72,chkView73,chkView74,chkView76,chkView77,chkView78,chkView79,chkView80,chkView81,chkView82,chkView83,chkView84,chkView85,chkView86,chkView87,chkView88,chkView89,chkView90,chkView51,chkView52,chkView53}; * CheckBox[] ChkAdd={chkAdd1, chkAdd2, chkAdd3, chkAdd4, chkAdd5, chkAdd6, chkAdd7, chkAdd8, chkAdd9, chkAdd10, chkAdd11, chkAdd12, chkAdd13, chkAdd14, chkAdd15, chkAdd16, chkAdd17, chkAdd18, chkAdd66, chkAdd67, chkAdd68, chkAdd19, chkAdd20, chkAdd21, chkAdd22, chkAdd23, chkAdd24, chkAdd25, chkAdd26, chkAdd27,chkAdd44,chkAdd64,chkAdd69,chkAdd70, chkAdd28, chkAdd29, chkAdd30, chkAdd31, chkAdd32, chkAdd33, chkAdd34, chkAdd35, chkAdd36, chkAdd37, chkAdd38, chkAdd39,chkAdd40, chkAdd41,chkAdd42,chkAdd43,chkAdd45,chkAdd46,chkAdd47,chkAdd48,chkAdd49,chkAdd50,chkAdd54,chkAdd55,chkAdd56,chkAdd57,chkAdd58,chkAdd59,chkAdd60,chkAdd61,chkAdd62,chkAdd63,chkAdd65,chkAdd71,chkAdd72,chkAdd73,chkAdd74,chkAdd76,chkAdd77,chkAdd78,chkAdd79,chkAdd80,chkAdd81,chkAdd82,chkAdd83,chkAdd84,chkAdd85,chkAdd86,chkAdd87,chkAdd88,chkAdd89,chkAdd90,chkAdd51,chkAdd52,chkAdd53}; * CheckBox[] ChkEdit={chkEdit1, chkEdit2, chkEdit3, chkEdit4, chkEdit5, chkEdit6, chkEdit7, chkEdit8, chkEdit9, chkEdit10, chkEdit11, chkEdit12, chkEdit13, chkEdit14, chkEdit15, chkEdit16, chkEdit17, chkEdit18, chkEdit66, chkEdit67, chkEdit68, chkEdit19, chkEdit20, chkEdit21, chkEdit22, chkEdit23, chkEdit24, chkEdit25, chkEdit26, chkEdit27,chkEdit44,chkEdit64,chkEdit69,chkEdit70, chkEdit28, chkEdit29, chkEdit30, chkEdit31, chkEdit32, chkEdit33, chkEdit34, chkEdit35, chkEdit36, chkEdit37, chkEdit38, chkEdit39,chkEdit40, chkEdit41,chkEdit42,chkEdit43,chkEdit45,chkEdit46,chkEdit47,chkEdit48,chkEdit49,chkEdit50,chkEdit54,chkEdit55,chkEdit56,chkEdit57,chkEdit58,chkEdit59,chkEdit60,chkEdit61,chkEdit62,chkEdit63,chkEdit65,chkEdit71,chkEdit72,chkEdit73,chkEdit74,chkEdit76,chkEdit77,chkEdit78,chkEdit79,chkEdit80,chkEdit81,chkEdit82,chkEdit83,chkEdit84,chkEdit85,chkEdit86,chkEdit87,chkEdit88,chkEdit89,chkEdit90,chkEdit51,chkEdit52,chkEdit53}; * CheckBox[] ChkDel={chkDel1, chkDel2, chkDel3, chkDel4, chkDel5, chkDel6, chkDel7, chkDel8, chkDel9, chkDel10, chkDel11, chkDel12, chkDel13, chkDel14, chkDel15, chkDel16, chkDel17, chkDel18, chkDel66, chkDel67, chkDel68, chkDel19, chkDel20, chkDel21, chkDel22, chkDel23, chkDel24, chkDel25, chkDel26, chkDel27,chkDel44,chkDel64,chkDel69,chkDel70, chkDel28, chkDel29, chkDel30, chkDel31, chkDel32, chkDel33, chkDel34, chkDel35, chkDel36, chkDel37, chkDel38, chkDel39,chkDel40, chkDel41,chkDel42,chkDel43,chkDel45,chkDel46,chkDel47,chkDel48,chkDel49,chkDel50,chkDel54,chkDel55,chkDel56,chkDel57,chkDel58,chkDel59,chkDel60,chkDel61,chkDel62,chkDel63,chkDel65,chkDel71,chkDel72,chkDel73,chkDel74,chkDel76,chkDel77,chkDel78,chkDel79,chkDel80,chkDel81,chkDel82,chkDel83,chkDel84,chkDel85,chkDel86,chkDel87,chkDel88,chkDel89,chkDel90,chkDel51,chkDel52,chkDel53};*/ int[] SubModules = { 4, 5, 12, 13, 61, 3 }; CheckBox[] ChkView = { chkView1, chkView2, chkView3, chkView4, chkView5, chkView6, chkView7, chkView8, chkView9, chkView10, chkView11, chkView12, chkView13, chkView14, chkView15, chkView16, chkView17, chkView18, chkView66, chkView67, chkView68, chkView19, chkView20, chkView21, chkView22, chkView23, chkView24, chkView25, chkView26, chkView27, chkView44, chkView64, chkView69, chkView70, chkView28, chkView29, chkView30, chkView31, chkView32, chkView33, chkView34, chkView35, chkView36, chkView37, chkView38, chkView39, chkView40, chkView41, chkView42, chkView43, chkView45, chkView46, chkView47, chkView48, chkView49, chkView50, chkView54, chkView55, chkView56, chkView57, chkView58, chkView59, chkView60, chkView61, chkView62, chkView63, chkView65, chkView71, chkView72, chkView73, chkView74, chkView76, chkView77, chkView78, chkView79, chkView80, chkView81, chkView82, chkView83, chkView84, chkView85, chkView86, chkView87, chkView88, chkView89, chkView90, chkView91, chkView92, chkView93, chkView94, chkView95, chkView96, chkView97, chkView98, chkView99, chkView51, chkView52, chkView53 }; CheckBox[] ChkAdd = { chkAdd1, chkAdd2, chkAdd3, chkAdd4, chkAdd5, chkAdd6, chkAdd7, chkAdd8, chkAdd9, chkAdd10, chkAdd11, chkAdd12, chkAdd13, chkAdd14, chkAdd15, chkAdd16, chkAdd17, chkAdd18, chkAdd66, chkAdd67, chkAdd68, chkAdd19, chkAdd20, chkAdd21, chkAdd22, chkAdd23, chkAdd24, chkAdd25, chkAdd26, chkAdd27, chkAdd44, chkAdd64, chkAdd69, chkAdd70, chkAdd28, chkAdd29, chkAdd30, chkAdd31, chkAdd32, chkAdd33, chkAdd34, chkAdd35, chkAdd36, chkAdd37, chkAdd38, chkAdd39, chkAdd40, chkAdd41, chkAdd42, chkAdd43, chkAdd45, chkAdd46, chkAdd47, chkAdd48, chkAdd49, chkAdd50, chkAdd54, chkAdd55, chkAdd56, chkAdd57, chkAdd58, chkAdd59, chkAdd60, chkAdd61, chkAdd62, chkAdd63, chkAdd65, chkAdd71, chkAdd72, chkAdd73, chkAdd74, chkAdd76, chkAdd77, chkAdd78, chkAdd79, chkAdd80, chkAdd81, chkAdd82, chkAdd83, chkAdd84, chkAdd85, chkAdd86, chkAdd87, chkAdd88, chkAdd89, chkAdd90, chkAdd91, chkAdd92, chkAdd93, chkAdd94, chkAdd95, chkAdd96, chkAdd97, chkAdd98, chkAdd99, chkAdd51, chkAdd52, chkAdd53 }; CheckBox[] ChkEdit = { chkEdit1, chkEdit2, chkEdit3, chkEdit4, chkEdit5, chkEdit6, chkEdit7, chkEdit8, chkEdit9, chkEdit10, chkEdit11, chkEdit12, chkEdit13, chkEdit14, chkEdit15, chkEdit16, chkEdit17, chkEdit18, chkEdit66, chkEdit67, chkEdit68, chkEdit19, chkEdit20, chkEdit21, chkEdit22, chkEdit23, chkEdit24, chkEdit25, chkEdit26, chkEdit27, chkEdit44, chkEdit64, chkEdit69, chkEdit70, chkEdit28, chkEdit29, chkEdit30, chkEdit31, chkEdit32, chkEdit33, chkEdit34, chkEdit35, chkEdit36, chkEdit37, chkEdit38, chkEdit39, chkEdit40, chkEdit41, chkEdit42, chkEdit43, chkEdit45, chkEdit46, chkEdit47, chkEdit48, chkEdit49, chkEdit50, chkEdit54, chkEdit55, chkEdit56, chkEdit57, chkEdit58, chkEdit59, chkEdit60, chkEdit61, chkEdit62, chkEdit63, chkEdit65, chkEdit71, chkEdit72, chkEdit73, chkEdit74, chkEdit76, chkEdit77, chkEdit78, chkEdit79, chkEdit80, chkEdit81, chkEdit82, chkEdit83, chkEdit84, chkEdit85, chkEdit86, chkEdit87, chkEdit88, chkEdit89, chkEdit90, chkEdit91, chkEdit92, chkEdit93, chkEdit94, chkEdit95, chkEdit96, chkEdit97, chkEdit98, chkEdit99, chkEdit51, chkEdit52, chkEdit53 }; CheckBox[] ChkDel = { chkDel1, chkDel2, chkDel3, chkDel4, chkDel5, chkDel6, chkDel7, chkDel8, chkDel9, chkDel10, chkDel11, chkDel12, chkDel13, chkDel14, chkDel15, chkDel16, chkDel17, chkDel18, chkDel66, chkDel67, chkDel68, chkDel19, chkDel20, chkDel21, chkDel22, chkDel23, chkDel24, chkDel25, chkDel26, chkDel27, chkDel44, chkDel64, chkDel69, chkDel70, chkDel28, chkDel29, chkDel30, chkDel31, chkDel32, chkDel33, chkDel34, chkDel35, chkDel36, chkDel37, chkDel38, chkDel39, chkDel40, chkDel41, chkDel42, chkDel43, chkDel45, chkDel46, chkDel47, chkDel48, chkDel49, chkDel50, chkDel54, chkDel55, chkDel56, chkDel57, chkDel58, chkDel59, chkDel60, chkDel61, chkDel62, chkDel63, chkDel65, chkDel71, chkDel72, chkDel73, chkDel74, chkDel76, chkDel77, chkDel78, chkDel79, chkDel80, chkDel81, chkDel82, chkDel83, chkDel84, chkDel85, chkDel86, chkDel87, chkDel88, chkDel89, chkDel90, chkDel91, chkDel92, chkDel93, chkDel94, chkDel95, chkDel96, chkDel97, chkDel98, chkDel99, chkDel51, chkDel52, chkDel53 }; try { for (int i = 0; i < Modules; i++) { for (int j = 0; j < SubModules[i]; j++) { PriviligesModel privilige = new PriviligesModel(); privilige.Login_Name = DropUserID.SelectedItem.Value; privilige.Module_ID = System.Convert.ToString(i + 1); privilige.SubModule_ID = System.Convert.ToString(j + 1); if (ChkView[a].Checked) { privilige.ViewFlag = "1"; } else { privilige.ViewFlag = "0"; } if (ChkAdd[a].Checked) { privilige.Add_Flag = "1"; } else { privilige.Add_Flag = "0"; } if (ChkEdit[a].Checked) { privilige.Edit_Flag = "1"; } else { privilige.Edit_Flag = "0"; } if (ChkDel[a].Checked) { privilige.Del_Flag = "1"; } else { privilige.Del_Flag = "0"; } //call the procedure ProPrivilegesEntry to save the data in Privileges table before take the //user id from user master table according to passing the user name in procedure after that //check this privileges ID exist or not if exist then delete the data of this priovileges id //after that insert the data in privileges table otherwise direct insert the data in privileges //table priviliges.Add(privilige); a++; } } using (var client = new HttpClient()) { client.BaseAddress = new Uri(BaseUri); var myContent = JsonConvert.SerializeObject(priviliges); var buffer = System.Text.Encoding.UTF8.GetBytes(myContent); var byteContent = new ByteArrayContent(buffer); byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); var response = client.PostAsync("api/PriviligesController/InsertPriviliges", byteContent).Result; if (response.IsSuccessStatusCode) { string responseString = response.Content.ReadAsStringAsync().Result; } } CreateLogFiles.ErrorLog("Form:Privileges.aspx,Method:btnSave_Click Privilegs of User " + uid + " Updated. " + uid); MessageBox.Show("Privileges Allocated"); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Privileges.aspx,Method:btnSave_Click EXCEPTION: " + ex.Message + " userid " + uid); } }