//FB Login
        public DataSet FbCorporateLogin(CorporateLoginBo loginBo)
        {
            var     transactionStatus = new TransactionStatus();
            var     consumer          = BuiltCorporateLoginDomain(loginBo);
            CemexDb con = new CemexDb();

            SqlParameter[] Params =
            {
                new SqlParameter("@Corp_mailid", consumer.Corp_mailid), //0
                new SqlParameter("@Corp_Pswd", consumer.Corp_Pswd),     //1
            };
            if (!String.IsNullOrEmpty(consumer.Corp_mailid))
            {
                Params[0].Value = consumer.Corp_mailid;
            }
            else
            {
                Params[0].Value = DBNull.Value;
            }
            if (!String.IsNullOrEmpty(consumer.Corp_Pswd))
            {
                Params[1].Value = consumer.Corp_Pswd;
            }
            else
            {
                Params[1].Value = DBNull.Value;
            }
            DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_FbConsumerLogin", Params);

            return(ds);
        }
 private CorporateLogin BuiltCorporateLoginDomain(CorporateLoginBo login)
 {
     return((CorporateLogin) new CorporateLogin().InjectFrom(login));
 }