Esempio n. 1
0
        public Int32 UpdateTempCard(TempCardModel tm, int id)
        {
            using (SqlConnection con = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand("tempcard_update", con);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@tmpno", id);
                cmd.Parameters.AddWithValue("@empid", tm.empid);
                cmd.Parameters.AddWithValue("@cardid", tm.tempcardno);


                cmd.Parameters.AddWithValue("@isdel", tm.IsDeleted);
                cmd.Parameters.AddWithValue("@isactive", tm.IsActive);


                cmd.Parameters.AddWithValue("@modifiedby", tm.modifiedby);

                cmd.Parameters.AddWithValue("@modifiedon", tm.modifiedon);
                cmd.Parameters.Add("@ret", SqlDbType.Int);
                cmd.Parameters["@ret"].Direction = ParameterDirection.ReturnValue;
                con.Open();
                // cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;
                cmd.ExecuteNonQuery();
                Int32 k = Convert.ToInt32(cmd.Parameters["@ret"].Value);
                con.Close();
                cmd.Dispose();
                return(k);
            }
        }
Esempio n. 2
0
        public IEnumerable <TempCardModel> GetTempCardDetails()
        {
            List <TempCardModel> lstcard = new List <TempCardModel>();

            using (SqlConnection con = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand("tempcard_display", con);
                cmd.CommandType = CommandType.StoredProcedure;
                con.Open();
                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    TempCardModel tm = new TempCardModel();
                    tm.tempno     = Convert.ToInt32(rdr[0]);
                    tm.empid      = Convert.ToInt32(rdr[1]);
                    tm.tempcardno = Convert.ToInt32(rdr[2]);
                    tm.IsDeleted  = Convert.ToBoolean(rdr[3]);
                    tm.IsActive   = Convert.ToBoolean(rdr[4]);
                    tm.addedby    = rdr[5].ToString();
                    tm.addedon    = Convert.ToDateTime(rdr[6]);
                    tm.modifiedby = rdr[7].ToString();
                    tm.modifiedon = Convert.ToDateTime(rdr[8]);

                    lstcard.Add(tm);
                }
                con.Close();
            }
            return(lstcard);
        }