public string CreateBudget(Budgetcode Bcobj) { cmd = new SqlCommand("spInsertNewBudget", con); con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BudgetName", Bcobj.BudgetName); //cmd.Parameters.AddWithValue("@Budgetdescription ", Bcobj.Budgetdescription); cmd.Parameters.AddWithValue("@BudgetStartDate ", Bcobj.BudgetStartDate); cmd.Parameters.AddWithValue("@BudgetEndDate ", Bcobj.BudgetEndDate); cmd.Parameters.AddWithValue("@SOStartDate ", Bcobj.SOStartDate); cmd.Parameters.AddWithValue("@SOEndDate ", Bcobj.SOEndDate); cmd.Parameters.AddWithValue("@ApproverStartDate ", Bcobj.ApproverStartDate); cmd.Parameters.AddWithValue("@ApproverEndDate ", Bcobj.ApproverEndDate); cmd.Parameters.AddWithValue("@Active ", Bcobj.Active); cmd.Parameters.AddWithValue("@CreatedBy ", Bcobj.CreatedBy); /*The output parameter*/ cmd.Parameters.Add("@BudgetCode", SqlDbType.VarChar, 100); cmd.Parameters["@BudgetCode"].Direction = ParameterDirection.Output; /*End*/ int count = cmd.ExecuteNonQuery(); string data = Convert.ToString(cmd.Parameters["@BudgetCode"].Value); con.Close(); cmd = new SqlCommand(); if (count != 0) { return(data); } else { return(data); } }
public bool CreateBudget(Budgetcode Bcobj) { cmd = new SqlCommand("spInsertNewBudget", con); con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BudgetName", Bcobj.BudgetName); cmd.Parameters.AddWithValue("@Budgetdescription ", Bcobj.Budgetdescription); cmd.Parameters.AddWithValue("@BudgetStartDate ", Bcobj.BudgetStartDate); cmd.Parameters.AddWithValue("@BudgetEndDate ", Bcobj.BudgetEndDate); cmd.Parameters.AddWithValue("@SOStartDate ", Bcobj.SOStartDate); cmd.Parameters.AddWithValue("@SOEndDate ", Bcobj.SOEndDate); cmd.Parameters.AddWithValue("@ApproverStartDate ", Bcobj.ApproverStartDate); cmd.Parameters.AddWithValue("@ApproverEndDate ", Bcobj.ApproverEndDate); cmd.Parameters.AddWithValue("@Active ", Bcobj.Active); cmd.Parameters.AddWithValue("@CreatedBy ", Bcobj.CreatedBy); int count = cmd.ExecuteNonQuery(); con.Close(); if (count != 0) { return(true); } else { return(false); } }