public int UserStatus(string UserNo, string ward, string booth, string sno, string localbody, string color) { try { EncDecArrayClass objenc = new EncDecArrayClass(); string[] uregid = UserNo.Split('$'); UserNo = objenc.DecryptInteger(uregid[0], uregid[1]); sqlCommand = new SqlCommand(); sqlCommand.CommandText = "[TrueVoterDB].[dbo].[uspInsertUserStatus]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(new SqlParameter("@user", UserNo)); sqlCommand.Parameters.Add(new SqlParameter("@ward", ward)); sqlCommand.Parameters.Add(new SqlParameter("@booth", booth)); sqlCommand.Parameters.Add(new SqlParameter("@sno", sno)); sqlCommand.Parameters.Add(new SqlParameter("@localbody", localbody)); sqlCommand.Parameters.Add(new SqlParameter("@color", color)); sqlCommand.Connection = sqlConnection; if (sqlCommand.Connection.State == ConnectionState.Closed) { sqlCommand.Connection.Open(); } int result = sqlCommand.ExecuteNonQuery(); return(CommonCode.OK); } catch (SqlException) { return(CommonCode.ERROR); } finally { sqlCommand.Connection.Close(); sqlCommand.Dispose(); } }
public int Responsibility(string UserNo, string ward, string booth, string sno, string localbody) { try { EncDecArrayClass objenc = new EncDecArrayClass(); string[] uregid = UserNo.Split('$'); UserNo = objenc.DecryptInteger(uregid[0], uregid[1]); sqlCommand = new SqlCommand(); sqlCommand.CommandText = "insert into [TrueVoterDB].[dbo].[Responsibility]([User],[WardNo],[BoothNo],[SNO],[Voted],[LocalBody])values('" + UserNo + "','" + ward + "','" + booth + "','" + sno + "',0," + localbody + ")"; sqlCommand.Connection = sqlConnection; if (sqlCommand.Connection.State == ConnectionState.Closed) { sqlCommand.Connection.Open(); } int result = sqlCommand.ExecuteNonQuery(); return(CommonCode.OK); } catch (SqlException) { return(CommonCode.ERROR); } finally { sqlCommand.Connection.Close(); sqlCommand.Dispose(); } }
public int insert(PollingData pollingData) { try { EncDecArrayClass objenc = new EncDecArrayClass(); string[] uregid = pollingData.userName.Split('$'); pollingData.userName = objenc.DecryptInteger(uregid[0], uregid[1]); string[] uregid1 = pollingData.refMobileNo.Split('$'); pollingData.refMobileNo = objenc.DecryptInteger(uregid1[0], uregid1[1]); sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@userName", pollingData.userName)); sqlCommand.Parameters.Add(new SqlParameter("@wardNo", pollingData.wardNo)); sqlCommand.Parameters.Add(new SqlParameter("@boothNo", pollingData.boothNo)); sqlCommand.Parameters.Add(new SqlParameter("@noOfVotings", pollingData.noOfVoting)); sqlCommand.Parameters.Add(new SqlParameter("@voters", pollingData.voters)); sqlCommand.Parameters.Add(new SqlParameter("@localBody", pollingData.localBody)); sqlCommand.Parameters.Add(new SqlParameter("@imeino", pollingData.imeino)); sqlCommand.Parameters.Add(new SqlParameter("@userType", pollingData.userType)); sqlCommand.Parameters.Add(new SqlParameter("@currentDate", pollingData.date)); sqlCommand.Parameters.Add(new SqlParameter("@refMoNo", pollingData.refMobileNo)); SqlParameter retrunParameter = sqlCommand.CreateParameter(); retrunParameter.Direction = ParameterDirection.ReturnValue; retrunParameter.SqlDbType = SqlDbType.Int; sqlCommand.Parameters.Add(retrunParameter); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = "[TrueVoterDB].[dbo].[uspInsertPollingData]"; sqlCommand.CommandType = CommandType.StoredProcedure; if (sqlCommand.Connection.State == ConnectionState.Closed) { sqlCommand.Connection.Open(); } int result = sqlCommand.ExecuteNonQuery(); if (Convert.ToString(retrunParameter.Value) == "1") { return(CommonCode.OK); } else { return(CommonCode.FAIL); } } catch (SqlException) { return(CommonCode.ERROR); } finally { sqlCommand.Connection.Close(); sqlCommand.Dispose(); } }
public string GetUserStatus(string userNo, string Ward, string localbody, string booth = null) //Change if need { try { PollindDataBLL bll = new PollindDataBLL(); EncDecArrayClass objenc = new EncDecArrayClass(); string[] uregid = userNo.Split('$'); userNo = objenc.DecryptInteger(uregid[0], uregid[1]); return(bll.GetUserStatus(localbody, Ward, userNo, booth)); } catch { return(CommonCode.WRONG_INPUT.ToString()); } #region Comment //XmlDocument xmlDocument = new XmlDocument(); //try //{ // PollingDataDAL pollingDal = new PollingDataDAL(); // DataSet ds = pollingDal.GetUserStatus(userNo, Ward, booth,localbody); // if (ds.Tables[0].Rows.Count != 0) // { // XmlDataDocument xmlDataDocument = new XmlDataDocument(ds); // XmlElement element = xmlDataDocument.DocumentElement; // return xmlDataDocument; // } // else // { // ds=CommonCode.ErrorDs(CommonCode.DATA_NOT_FOUND.ToString()); // ds.Tables[0].TableName = "ErrorTable"; // XmlDataDocument xmlDataDocument = new XmlDataDocument(ds); // XmlElement element = xmlDataDocument.DocumentElement; // return xmlDataDocument; // } //} //catch (Exception ex) //{ // XmlWriter writer = xmlDocument.CreateNavigator().AppendChild(); // writer.WriteStartDocument(true); // writer.WriteStartElement("Error"); // writer.WriteString(Convert.ToString(ex.Message)); // writer.WriteEndElement(); // writer.WriteEndDocument(); // writer.Close(); //} //return xmlDocument; #endregion }